yea that was it. Thanks guys. I should have known that. I had the same issue in the past when implimenting SFTP.

Thanks for your help and timely response!

equally as odd is the fact that my qury anal conn shows disconnected when it errors.

i had the same issue except i was conn to sql server.

i had to delete everything and rebuild it with my flat file code page to = 1252 ...

thanks guys. that worked.

Here is what i used.

EXECUTE msdb.dbo.sysmail_configure_sp

'MaxFileSize', '1000000000'

What do you want to monitor? Fortunatly sql stores all sorts of interesting things about itself that you have access to query.

just a suggestion.

delete from kundenrepl.dbo.tbl_kraft_bss_txt

where id in

...

this might be pretty informative to see what raplication is doing. I have this being run every 5 mins and emails me when latency is above a predefined threshold.

SELECT dl.publisher_db,

...

u saying u need table created? record inserted? A select from a table?

i would also go into sql server config manager and create an alias for the box however u dont have to.

u can build the linked server in the managment studio interface by going to server objects then linked servers. Add new linked server and there is a security tab for...

sry. i'm an idiot. apparently my function lock was on. new keyboard. sorry

i found the issue here

the ssis runs fine when i run it manually in bus intel stud

assumeing that the entire 50 will be prepended w/ zeros each time you can always use replicate function to put the zeros back. You didnt send desired example output so...

i'm not accustom to joining tables w/o something in both tables having something related.

you may have to just loop. Also i would suggest sending your table structures and some sample...