Viewing 15 posts - 46 through 60 (of 3,232 total)
duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx
June 2, 2016 at 1:42 pm
duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx
June 2, 2016 at 1:41 pm
duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx
June 2, 2016 at 1:41 pm
duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx
June 2, 2016 at 1:41 pm
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...
June 2, 2016 at 12:16 pm
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...
June 1, 2016 at 7:53 am
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...
May 31, 2016 at 9:51 am
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...
May 26, 2016 at 1:09 pm
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...
May 25, 2016 at 4:29 pm
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
May 25, 2016 at 3:18 pm
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. ...
May 25, 2016 at 8:00 am
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...
May 24, 2016 at 3:12 pm
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....
May 24, 2016 at 12:33 pm
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...
May 24, 2016 at 12:20 pm
Viewing 15 posts - 46 through 60 (of 3,232 total)