Viewing 4 posts - 1 through 4 (of 4 total)
Its actually not a warning....its is an actual error caused the setting 'Fail Package'(or FailTask) on the 'Truncation'. You can set it to 'Ignore Failure' on Truncation and it will...
August 28, 2012 at 7:00 pm
You can set up an ExecuteSQLTask. Put the call your sp as :
exec testing.dbo.proc_TEmptest ?,?
(The '?' are the place holders)Now map these two question marks to the SSIS variables in...
August 28, 2012 at 6:53 pm
Yes very true......
This seems to be a like a very simple mapping. Just create a DataFlow task. Define a source and a destination and have a derived col transform in...
August 28, 2012 at 6:43 pm
Not sure why you have the variable 'Server' set up with a Datatype of Object.
Second
Not sure if just saying 'aquireconn' in the foreach will mean you arfe testign connectivity.
Email sending...
August 28, 2012 at 9:21 am
Viewing 4 posts - 1 through 4 (of 4 total)