Viewing 8 posts - 16 through 23 (of 23 total)
Have you set the expression on the FTP container to dynamically select the appropriate file from the next file in the ForEach loop? Try creating a variable on the...
November 24, 2010 at 4:15 pm
You can see the examine the sysssispackages in the dbo schema for package names and creation dates, but this date is the date stored in the package of when the...
November 24, 2010 at 3:30 pm
If your FTP connection is dependant on any of the other tasks you can get this, even though the precedence constraints are in place, unless you delay the validation of...
November 24, 2010 at 2:51 pm
Have you executed the AquireConnection method on the wrapper in your code? Essentially, that's what happens when you open the connection component in your data flow.
November 24, 2010 at 1:53 pm
1. In your package create a variable to hold the name of your sequence container.
2. Select your sequence container, then click the Event Handler tab, next to the Data Flow...
November 23, 2010 at 1:19 pm
It appears as though you may have a line that don't have as many fields as you think so when you get past field10, there are no more "," in...
November 23, 2010 at 9:27 am
I don’t know if your efforts are for a class project, due at the end of the week, or for an enterprise class data store with a well defined service...
November 23, 2010 at 8:26 am
Try this:
See Attachment
You can also do this by adding a Date table to your schema; that would provide scaleability when you start adding holiday, days off ect. Let me...
November 7, 2010 at 1:45 pm
Viewing 8 posts - 16 through 23 (of 23 total)