Groups | Blog | Home
all groups > sql server dts > february 2007 >

sql server dts : Deploying Solution (packages) with Data Source Views


Pasha
2/6/2007 4:18:01 PM
Hi,

When I create a deployment utility in SSIS, it copies DTSX files to a
specified directory and creates the deployment configuration file. Nothing
references the Data Source Views that I have created. I am planning to
import all of the packages to SQL Server, but they would not run without Data
Source Views. I am stuck here. Any help would be appreciated.

Thanks,
Allan Mitchell
2/7/2007 1:28:50 AM
DSVs are at the project level and not needed by SSIS. Connection
Managers which may or may not come from Project Data Sources are used in
the package and they are stored within the .dtsx file.



--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com



[quoted text, click to view]
AddThis Social Bookmark Button