i think i found it...

yes, i believe he uses bigint as his pk's.  do you think that has something to do with this?

i believe our infrastructure folks told him there was a server failure around the time of his inserts.   i'll post back here once i get some details.

correction , no failures...

• This reply was modified 2 weeks, 3 days ago by stan.

this is looking more promising for my needs, maybe not yours.   i'll have to figure out how to allow single quote marks, probably by using the replace function.  There is...

hard lesson, i guess that sql statement doesn't do what i was hoping, ie hold true in the when clause if even one character is not in the list.  i...

wow this is confusing.   for starters i dont know what an object type of 50 (with parameter name SYNCHRONIZEFD, and maybe setting my pkg level param in the same EXEC)...

• This reply was modified 1 months, 3 weeks ago by stan.
• This reply was modified 1 months, 3 weeks ago by stan.
• This reply was modified 1 months, 3 weeks ago by stan.

im circling back to this right now.   bear with me.

thx jeff.   this is a db in an off the shelf erp.   its probably not just one table.   we cant add things like that without voiding our contract, at least...

• This reply was modified 2 months, 1 weeks ago by stan.
• This reply was modified 2 months, 1 weeks ago by stan.

i just ran the pkg from sql agent.   I dont want to guess especially since you'd think strongly named assemblies etc should have been in play.   If anyone in the...

i'm not sure how this is going to go but i added winscp to gac on the prod server,   imported the already deployed pkg, edited both c# scripts and see...

• This reply was modified 3 months ago by stan.
• This reply was modified 3 months ago by stan.

thx frederico, im kind of intrigued more by the exec path example (example 1 as opposed to the gac workaround in example 2 of your link) only because the code...

• This reply was modified 3 months ago by stan.
• This reply was modified 3 months ago by stan.

thx Tung, that was already tried in dev as i wrote in the post.

how would you go about adding .dll refs to a c# script in ssis once its in...

• This reply was modified 3 months ago by stan.
• This reply was modified 3 months ago by stan.

thx Jo, couldnt they just as easily send sql into a tailspin from another client where they are coding their query?   and do you find ssms that difficult in exporting...

it looks like the connection string property is the one to set in a flat file connector , not name.   this might be the answer.