473,385 Members | 1,780 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

need help in SSIS ETL development

Hi all,

I am a newbie to SSIS.Need a solution to couple of issues I am
currently facing while developing ETL in SSIS

1) Under SSIS Package Folder I have defined mappings for 17 dimensions.
1st Dimension say Account has been Set up as a startup object.
Now when I run the package ir runs only my account dimension and loads
the target,other dimensions are not run at all!

Arent the other dimensions run in the order present in SSIS Package
Folder? If not how are they to be connected with each other?

2) Second issue is of passing parameters in an Execute SQL task.
I have defined 3 variables with the scope of Package Level.
3 parameters have been mapped to these 3 variables. Parameters are a
part of the SQL,but are not getting parsed.
I need to pass them somehow? Can anyone suggest how?

Please give your inputs SSIS gurus.

Thanks in advance.

Regards,

Aman Anand

May 30 '06 #1
0 1798

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: stant | last post by:
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have...
0
by: Rodrigo Bellusci | last post by:
I´m using the following code to execute a SSIS package: string pkgLocation; Package pkg; Microsoft.SqlServer.Dts.Runtime.Application app; DTSExecResult pkgResults; pkgLocation =...
1
by: Eric | last post by:
In MS Excel, the ability exists to run a "web query." This function is accessed via the data menu's import external data option. The web query wizard accepts a URL address, and then is able to...
0
by: hoots | last post by:
The Problem: I want to be able to use an assembly of an independant application which is not strong named from within an SSIS script component. I have created a wrapper assembly (Utils.dll)...
0
by: dharper | last post by:
Hi! I'm new to sql 2005 and need to run an automated report that is a fairly simple fixed width ragged right report. Problem is I need a header in the report that has static text, plus the rowcount...
9
by: gelangov | last post by:
I have 2 variables, one is the column name of the table and the other one is the table name and I need to write this in the "Execute SQL task" of a "For each loop" container in a ssis package like...
0
by: Mike Martin | last post by:
I have an SSIS package that runs against a DB2 database. It is currently pointing to the development instance. I've tried to make a variable for the scema name, so I can change it when it goes...
6
by: jags_32 | last post by:
We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data from a Double Byte Progress database and the...
0
by: sam12 | last post by:
Hi Everyone I made a SSIS project in " SQL SERVER business intelligent development Stuidio"which has only a FTP task . When i run this project it doesn't give any error and FTP successfully but...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.