Viewing 15 posts - 3,241 through 3,255 (of 11,678 total)
Duplicate post. Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1562726-3411-1.aspx
April 17, 2014 at 10:19 am
kbnyny (4/17/2014)
April 17, 2014 at 7:44 am
dopydb (4/17/2014)
i logged in on the same account that the sql agent service runs under, changed security of the package to"encrypt sensitive with userkey"
sis package now runs fine!
You should...
April 17, 2014 at 5:21 am
mr_effe (4/17/2014)
So can you also give me some hints what i...
April 17, 2014 at 3:50 am
Anyone with a better grasp of partitioning and locking can chime in on this one?
http://www.sqlservercentral.com/Forums/Topic1562552-391-1.aspx
April 17, 2014 at 3:33 am
mr_effe (4/17/2014)
thanks for the fast answer. But is there no other chance to load the table at the same time? Because i thought that because of the partioned tables...
April 17, 2014 at 3:31 am
dopydb (4/17/2014)
do i need to change protection level - should it be "encrypt sensitive with password?"i can only run the app out of hours hence why i cant test now
That...
April 17, 2014 at 3:18 am
dopydb (4/17/2014)
i have an ssis job, which runs various calculations, creates a .txt file and then uploads to an FTP site.
when i run it in bids it works fine,...
April 17, 2014 at 3:02 am
Is it an option to create a report? (it will be much easier)
April 17, 2014 at 3:01 am
You can load a data warehouse in parallel, but I would try to avoid loading a table by multiple processes at once.
Try loading different tables at the same time.
April 17, 2014 at 3:00 am
kbnyny (4/16/2014)
yes I refresh the flat file destination metadata
Did you look for the full error?
April 17, 2014 at 12:21 am
kbnyny (4/16/2014)
When I change encoding to unicode and the data type DT_NTEXT to that this is...
April 16, 2014 at 3:16 pm
kbnyny (4/16/2014)
Here is a screen shot of the error, not sure if this will work.
You cannot post directly from your own hard drive.
You can upload an image as an...
April 16, 2014 at 3:09 pm
Viewing 15 posts - 3,241 through 3,255 (of 11,678 total)