duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx

duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx

duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx

duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx

So you are able to log into the second server as the account that runs your package?

Another thing you can do is put a breakpoint on one of your tasks...

Is this a question? This is a very old thread, you should start a new thread and give us a bit more details into what you are attempting to...

You need an execute SQL task inside of your for each loop container. Your UPDATE statement should be something like this:

UPDATEtableA

SETDirectory = Directory + ?

Then, on the Parmeter...

Glad you're back up and running. I agree with Thom here that you should consider version control. We store all of our .rdl files off in version control...

You can use an OLE DB Source w/o having to place the stored procedure code inside the SQL command text. You put the stored procedure call into the SQL...

You need to set up a for each container to iterate over the .txt files in your directory. Here's an example of how to set that up.

http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx

..

I have been out of the Teradata world for around a year now. I never really found a good Teradata community like we have here for SQL Server. ...

You need your execute SQL task to use the connection manager that you've setup to use the dynamic server name from the foreach loop variable. Here's a link that...

If you need to change connections, you can make your connection manager dynamic by using the expressions on it and the variable from your foreach loop containing the server name....

There are resources that will be much better for you in regards to Teradata than this site. Are you a Teradata user or admin? Trillions of rows is...