DTS help
-
I have to create a DTS package.
Which reads data from a FTP site, and write it to a table and that
table must be linked to the other table.But my problem is here I have to
check the condition whether the data has been written to ftp server at
the specified time, before loading it and I have to give a loop
condition to read each and every row into a table.And I have to link this
table to other table.
I can understand that this thing is real mess. But if you can throw
any idea on this, it would be highly appreciated.
Thanks.
-
Dear
as i understand that you wana copy copy/ftp the data from source server to destination server
but before sending/ftp/copying the data on destination server you need to confirm that the old has been
copied on destination server or not if yes then u could update/inert into database .
Solution
my
dear if gona DTS packege it will just go from source to destination it will not check the data either it has copied or not u know its a single side
authentication ther is no chance to acknowledge the data and then copy.
but if u go sql server job you can get the actuall result through link server as well.
because it provide vice versa authentication method.
just try it i have just given you idea may be it will help you b/c i have done this thing in my org and i got actuall result
Regards
Syed Muhammad Naveed
Database Administrator
-
Check http://www.sqldts.com. They'll have an example of checking for the existence of the file.
--------------------
Colt 45 - the original point and click interface
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply