Integration Services | Forum profile

Let me guess, this FTP task was at one time coded in some other system or application, and now you are trying to get it to work inside SSIS. Why are you *writing* code to do something that can be performed by components already designed into SSIS? Have you looked at the FTP task? Looks like you are trying to pull in multiple files. Can you put the FTP task inside a ForEach loop? In SSIS, just about *every* property of *every* task or component...

thanks for responding. The reason why I write code instead of using a FTP task (receive files) is the fact that a FTP task plus the entire package fails when the remote folder contains no files. To work arround this I choose the Script task that allows me to determine the number of files in the folder first and then do a ftp receivefiles in case the number of files > 0. I' haven't found any methods on how to do that with a...

Yes, this can be done, and John Welch has two great blog posts on this topic: Part 1 (requires scripting) - http://agilebi.com/cs/blogs/jwelch/archive/2007/06/03/multi-file-output-destinat ion-script-component.aspx Part 2 (does not require scripting) - http://agilebi.com/cs/blogs/jwelch/archive/2007/06/03/multi-file-outputs-part-2.aspx Phil ssistalk.com

Hi, I am trying to execute 80 or so child packages from within the main package through a Script Task that calls the "App.LoadPackage()".  All of the the package use the Package Configuration for establishing connection.  When I execute the master workflow or main package in Designer, all of the packages are executed and main package complete successfully.  However, when I execute the main package...

I am trying to import some XML data from the National Oceanic and Atmospheric Administration (NOAA) and I am running into roadbloks at every turn. XML file: http://www.weather.gov/xml/current_obs/KMCE.xml XSD file: http://www.weather.gov/view/current_observation.xsd I can't get SSIS XML Source to see beyond the imageType. Any thoughts on how I can import the above xml in to a dB, I would really appreciate it. Pleasae note Newbie to SSIS...

I suppose you mean a "SQL Agent Job" > it does not run successfully, nor is it > giving me any helpful error messages to point me in the right > direction. > > I have Googled, I have newsgrouped, and I even asked folks at my > firm.  No one seems to know why.

Sigh.....it's really hard for me to explain the situation.  But, I'll do my best. I successfully created a SQL package file (.dtsx).  I'm simply trying to put it in a SQL SSIS job.  it does not run successfully, nor is it giving me any helpful error messages to point me in the right direction. I have Googled, I have newsgrouped, and I even asked folks at my firm.  No one seems to know why. I...

what's the error? is it something about a key? we had that one and now we encrypt our packages with a password and they run just fine

Hello all, I'm trying to set up an SSIS Package where the 1st data flow task will read from a text file, perform all necessary transformations, and then have the results available to the 2nd & 3rd Data Flow Task's as source data. I guess I could set the package up to create a pseudo-temp table ([ClientDB].[sDELETE].[CoreData]) and send all my results from the 1st task to this table...then it'd be available to tasks 2...

See Jamie Thompson's blog post here: http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using- temporary-tables.aspx ...the upshot is that you can use temporary tables in SSIS, but I would wager that the effort required to do so outweighs any potential benefits. A possible alternative to having a staging table (a table in your sDELETE schema) would be to use a raw-file destination - i.e. have the data dumped out to...