Yes, this is most likely a security issue.  More than likely the account your SQLServerAgent is using no longer has access to the files you want to import.  To find...

Perhaps it's a syntax issue, are there any errors being reported?  Have you turned on logging on the package itself and also if you're calling it from the cmd line...

Yeah, Sometimes it just helps to have another set of eyes take a look at something.  I have a freind that routinely makes things more complicated than they have to...

More than likely you're problem lies here...

"Cannot insert the value NULL into column 'nomEmple', table 'bdValeE.dbo.tbSaldos'; column does not allow nulls. "

What is different about the data when you...

Can I ask a Silly question?  How's come you are using DTS to load your data from the text file and not CF?  You could use a txt file datasource...

Yeah, All I'm saying is that you should have your Sproc return a value 0 for everythign went ok, 1 for a problem or whatever you choose.  Then in your...

Yes you could shut down remote access to your SQL server the easiest way would probablys be either at your border router, or your firewall during times while you are...

You could add a failure constraint to the last step in your package.  If it fails you package fails, and if something else fails before that your package fails... You...

Resource domains came from Windows NT and were things that most companies started to get away from once active directory came around.  If you're interested you could read about them...

I'd suggest that if you are only putting them in that group for the sake of SQL sercurity and have no other security or distribution access levels controlled by that ...

The VPN bit would be the solution for you, a cheap CISCO Pix VPN can be obtained for around $425 and they're very easy to configure, however if you can't...

That worked perfectly.  Thanks very much.

Yeah it was Disconnected Edit|connections|textfile(destination)|OLE DB Properties | Max Characters per delimited Column.

What was your question?  you said "One question though"  and nothign more.

What Markus said was correct.  MS SQL is a much more mature database system.  It provides you with many things that MY SQL doesn't.  But at the end of the...

ok I see what you're doing, Set up the entire select into variables instead of half and half.

Thanks.

I guess this is all mute because I was able to acomplish it using Temp Tables, but I'd still be interested in any ideas on what I was doing wrong...