DTS question

I have package that Extracts a zip file. Now the zip file is updated bi-weekly between 9-11am. So the DTS package is schedule to run at 9am. Once the zip is extracted it is renamed (different from original).

But before extraction, i have a few tasks that check whether the zip exists or not.

PROBLEM: If the zip new file exists at 9am, it's all good and the package will be successful. The problem i'm facing is, say the zip file is not available at 9am, I want the package to check if the file exists - every x minutes till 11am.

This polling for the file is creating a alot of problems for me.

Any help/advise would be appreciated.

ThanksHello!

I assume that you have an ActiveXTask as one of the first steps in that DTS Package, that checks the existence of the ZIP-File.

If you make this task loop until it finds the ZIP-File, that would be the first step. In this loop there should be a command that calls a VBScript with something like "WScript.Sleep 600000" (which should stop the script from continuing for 10 minutes!).

Hope that gave you some hints!

Greetings,

Carsten

Originally posted by vmlal
I have package that Extracts a zip file. Now the zip file is updated bi-weekly between 9-11am. So the DTS package is schedule to run at 9am. Once the zip is extracted it is renamed (different from original).

But before extraction, i have a few tasks that check whether the zip exists or not.

PROBLEM: If the zip new file exists at 9am, it's all good and the package will be successful. The problem i'm facing is, say the zip file is not available at 9am, I want the package to check if the file exists - every x minutes till 11am.

This polling for the file is creating a alot of problems for me.

Any help/advise would be appreciated.

Thanks

dts only selected rows

I have to dts rows by timestamp. For example if my dts downloaded at 10 am then in the next run i want to grab rows updated in the AS400 after 10am. what is the best way to go in ssis?

thanks...

kushpaw

You'll have to store the timestamp somewhere - perhaps in a file or a table, and then use a dynamic SQL statement using that timestamp.

-Jamie

|||

Perhaps, consider to use some sort of execution/audit tables and have your packages to get data extraction timeframesfrom there each time .

Rafael Salas

|||

There is a timestamp field in both sql and as400 tables. I can select the last timestamp from the destination table and query source for that timestamp. Is that what u mean?

-kushpaw

|||

kushpaw wrote:

There is a timestamp field in both sql and as400 tables. I can select the last timestamp from the destination table and query source for that timestamp. Is that what u mean?

-kushpaw

Yeah something like that. That would work.

|||thanks for your suggestion Rafael. this would be an ssis way, just what i was looking for.

DTS Import Wizard fails

I am trying to copy updated tables from a DB on a remote SQL server to
my pc using import wizard. I choose "copy objects and data between SQL
Server databases". On the screen "Select objects to copy", all of the
options are unchecked/blank including the script location. Clicking
"select objects" causes the wizard (and enterprise manager) to crash.
An error message refers to mmc.exe. Any ideas?Hi

This sounds like an error with EM itself, is this a one off or re-creatable?
You may want to check that the client tools are up-to-date. To avoid network
problems, it may be easier to restore a backup to a copy database and then
do the updates.

John

"SkyBlue" <aajjww@.postmaster.co.uk> wrote in message
news:60c756c.0407300546.664df6ba@.posting.google.co m...
> I am trying to copy updated tables from a DB on a remote SQL server to
> my pc using import wizard. I choose "copy objects and data between SQL
> Server databases". On the screen "Select objects to copy", all of the
> options are unchecked/blank including the script location. Clicking
> "select objects" causes the wizard (and enterprise manager) to crash.
> An error message refers to mmc.exe. Any ideas?