April 3, 2014 at 1:34 am
I would like to know how to check for existing ssis package in file system for example in c drive or it is in folder using dtutil exe /EXISTS
command.
The one I tried did not give me correct result.
i.e:
dtutil /file c:\mypackage /EXISTS
Thank you
April 3, 2014 at 3:38 am
Following are the extract from the BOL:
To determine whether a package exists in the local file system, use the following syntax:
dtutil /FILE c:\srcPackage.dtsx /EXISTS
To determine whether a package exists in the msdb database on a local instance of SQL Server that uses Windows Authentication, use the following syntax:
dtutil /SQL srcPackage /EXISTS
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 9:55 am
Why not use a staging area to load 4 tables and later use a union to create one table
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply