Re: Some queries regarding SSIS ETL Development

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello AMAN,

If i read you correctly you have 17 packages?

OK if this is the case then these objects are independent of each other. The package folder in BIDs is simply an organiser nothing more. If you want to call each of those packages and in order then I would be looking at the ExecutePackage task along with workflow constraints between those package calls.

For the Funky new ExecuteSQL task please take a look at this article

The ExecuteSQL Task
(http://www.sqlis.com/default.aspx?58)


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

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



.

Relevant Pages

  • Re: Question about generics.
    ... generic package, as you say. ... It is more interesting for cases unrelated to generics: ... static String) return static Float; ... unknown dimensions at run-time. ...
    (comp.lang.ada)
  • Macintosh Java Applet Please Help
    ... I want to serve a web page using a Java applet called jmol that models ... molecules in three dimensions. ... I downloaded the package and read through the docs. ...
    (comp.lang.java)
  • Re: eBay Scenario
    ... only took the weight into consideration and not the package size. ... dimensions when listing the item. ...
    (rec.collecting.coins)
  • Re: Shipping heavy 30lbs+ with UPS
    ... >>>I'm planning on shipping via UPS. ... >> I believe it makes a difference how big the package is also. ... Figure out about what the dimensions would end up being both ... > A movie screen costs $7 extra sometimes. ...
    (alt.marketing.online.ebay)
  • RE: Run a ssis package on SQL Server 2005 Error
    ... Failure saving package. ... This is most likely a known issue in SQL Server 2005, ... Set the SSIS Package ProtectionLevel property to ServerStorage ...
    (microsoft.public.sqlserver.dts)