October 24, 2008 at 1:50 am
hi,
ERROR 1 :
i copied SSIS package from production (using visual studio 2005 ) to my local system to make some changes .
but when i open it on my local system ( visual studio 2005 ) and start debugging it is showing dtsxConfig was not found
EEROR 2 :
i got another ERROR ..actually i m using a VB script file ....it is showing error on line :
Dim CEUpgrader As New System.Data.SqlServerCe.SqlCeEngine
"System.Data.SqlServerCe.SqlCeEngine" is not defined
i have sql server 2005 mobile edition on my system
Do i need sql server 2005 compact edition ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2008 at 10:24 am
Hi,
The configuration files are not copied, when you copy or deploy packages. You need to copy Config files seperately and set up however it was set up in production.
If it is in Environment variable, you need to do so in your local also, if it is stored local folder then you need to put your Config files in the same folder as it was in production.
VG
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply