Viewing 15 posts - 1 through 15 (of 36 total)
I am assuming you are getting the error in a script task. That happens when you are trying to access a vraibale inside the script without first specifyinf it on...
October 9, 2012 at 12:36 pm
First the answer to your question.....the procs will continue to run (i think) because once the are engaged by the ssis, even if SSIS completes, sprocs will continue.
But i...
October 9, 2012 at 12:32 pm
try playing around with the datatype of the empname on the source between WSTR and DWSTR.
September 15, 2012 at 5:12 pm
800000 is not a huge number but still larger than, say, 3000-4000 rows in oracle. Please follow the pattern of having a stage table in between your ssis and the...
September 15, 2012 at 5:10 pm
The below is yopur error :
Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access...
September 14, 2012 at 9:09 am
Hi Hari
please provide more detailed specs on the question. For this question, its not that the quesion is not clear.....but still people would like to get more detailed question with...
September 13, 2012 at 1:44 pm
If you have the .msg already somewhere and want to save it else......should be simple in ssis using FST.
But , lets say, if you want to extract .msg from outlook...
September 13, 2012 at 1:33 pm
Everything the fellow reponder (PP) said :
Break doen into smaller queries
Write short expressions(maybe even shorter variable names)
Parametreized stored proc
Might i also suggest :
Have a .sql file in which you write...
September 13, 2012 at 1:01 pm
After building your package (i am assuming you built it in BIDS) you have to deploy the .dtsx file to the SQL Server store in SQL Server Integratiobn Services. Only...
September 13, 2012 at 12:58 pm
I think you are using a third party task called BizCrypto OpenPGP Protect Task. It has to do with that. Please ensure the respective keys for encryption / decryption are...
September 13, 2012 at 12:39 pm
Well, your question is quite detailed. Might i still ask another question. When you say you link src to DEST1 it automaps but when you go to DEST2 it does...
September 13, 2012 at 12:35 pm
Please be more detailed in the questions :
do you mean you have 4 excels with the diff column sets you provided.
do you just have one excel with the header row...
August 30, 2012 at 1:07 pm
the examples you had sent had the format :
Last Name, First Name, Middle Initial
So yes, granted, i interchanged the LastName and the FirstName labels. In my post, please understand 'FirstName'...
August 30, 2012 at 1:04 pm
You cab try using the Export Column transform. This is specifically meant for datatypes like DT_NTEXT etc.
August 29, 2012 at 8:01 pm
Use multicast on the excel......load id and name cols(from source 1 of multicast) to table 1 and all the addresses in col1, col2, col3(from source 2 of multicast) to table...
August 29, 2012 at 7:58 pm
Viewing 15 posts - 1 through 15 (of 36 total)