Viewing 15 posts - 16 through 30 (of 195 total)
Griffster (2/17/2010)
An example is that it sees the time in Sybase (Sybase 11) table as 12:52:39.000, but SSIS sees the value as a DT_I8 with a value of 463590000000.
Looks like...
February 24, 2010 at 9:09 am
Do you mean if I have no other variables I need to pass to the parent package aside from those used in the child and thus no need for a...
February 24, 2010 at 9:02 am
Does this then mean I don't have to use parent package variable configurations in the child? Interesting, so the child is calling c.dtsconfig. saj1 will override this with a.dtsconfig at...
February 24, 2010 at 7:57 am
You're almost there too 😀
Copy either a.dtsconfig or b.dtsconfig to c.dtsconfig.
Make one minor change to x.dtsx to use the configuration in c.dtsconfig.
Running the package from saj1 or saj2 will continue...
February 23, 2010 at 10:47 am
OK, I think I see where you are heading 🙂
You can dynamically change the connection used by the Execute Package Task using a variable in an expression (the exact method...
February 23, 2010 at 9:16 am
I'm still guessing what you're trying to do, but here's another suggestion.
If the package is the same, but only the configuration is different, here is what you can do: in...
February 23, 2010 at 7:55 am
February 23, 2010 at 12:08 am
What are you trying to do? What is the value of @Col? If you want @Col to represent the name of the column on which to filter, you'll either have...
February 23, 2010 at 12:02 am
Veena,
Open the connection manager for the flat file.
On the first tab (General), select "Column names in the first data row".
This should do the trick.
February 22, 2010 at 11:53 pm
Griffster (2/22/2010)
February 22, 2010 at 9:50 am
Elliott W (2/22/2010)
February 22, 2010 at 9:13 am
In the child via BIDS.
February 22, 2010 at 9:12 am
You can reuse the child's configuration file in the parent and then add extra configurations in the parent package (e.g. you can have more than 1 configuration file in a...
February 22, 2010 at 6:48 am
You can use package configurations in both the parent and the child package independently. The configurations for the child package should be defined in that package, not in the parent...
February 22, 2010 at 4:26 am
What error log files are you referring to?
Can you explain how these error log files are currently generated, what they look like now and what you would like them to...
February 22, 2010 at 1:42 am
Viewing 15 posts - 16 through 30 (of 195 total)