Viewing 15 posts - 12,256 through 12,270 (of 13,849 total)
Not sure about that 'bug', but why not simply move the processed files to another folder (/Archive, for example)? It's tidier and your problem will go away.
February 20, 2010 at 1:18 am
Please include a question or two in your post.
February 19, 2010 at 12:27 pm
Does the SQL Agent service user have the requisite privileges to access the other servers?
February 19, 2010 at 9:19 am
Then there is a suggestion that the time increase gets worse as each package runs.
Can you swap, say, Master1 and Master3 to confirm this?
It would be useful to know...
February 18, 2010 at 2:01 am
It would be useful background if you would explain a bit about what the packages are doing - what is Master3 doing that the other 2 are not?
February 18, 2010 at 1:33 am
Are the quotes appearing as text-field qualifiers? Or just noise in your file that you want to delete? Do you mean single or double quotes? I omitted to mention the...
February 17, 2010 at 6:19 am
Pipe-delimited files can generally be imported just fine with the flat-file source & if I were you I'd spend more time trying that method before wading into script. Presumably you...
February 17, 2010 at 3:52 am
It is common practice to move a file to an archive folder of some sort after processing it - perhaps adding 'processed date' to the file name in the process.
If...
February 17, 2010 at 12:34 am
Is Converted_My_VALUE always numeric, or is it sometimes NULL? Can you give an example of some of the data it contains when it is failing?
February 16, 2010 at 1:07 am
You obviously need to create a job to run the package before trying that idea ... it should work.
February 15, 2010 at 7:50 am
I think I know what you've done. Your destination cannot have more than one input.
You need to delete the mapping from source to destination. Then add source to derived column...
February 14, 2010 at 8:23 am
touchmeknot123 (2/13/2010)
...Is there any other way to solve the problem since these settings will have to be changed in the production server as well.
Thanks in advance.
If you can use CSV...
February 14, 2010 at 12:51 am
It's simple to do this - add a Derived Column transformation with one new column and set its value to "X".
Now map this new column to your destination column as...
February 13, 2010 at 12:24 pm
Viewing 15 posts - 12,256 through 12,270 (of 13,849 total)