In a SSIS-project you can set the property “Create deployment utility” to true. When building such a project you may get the error
“Could not copy file xxx.dtsconfig to the deployment utility output directory. File already exists.”
This was due to two packages using the same config file and Visual Studio wants to copy that [...]
I tried to conect to SSIS and got the error “SQL-server does not allow remote connections”(rougly from the top of my head). Turned out that the server i was connecting to needed SSIS to be confugured to run against a specified instance of SqlServer.
SSIS runs as standard at the default instance (i.e localhost). this [...]
A DTSX-package with lot of faulty connections can be very hard to edit due to SSIS trying to resolve all the connections.
First try to edit in offlinemode (Note: you cannot test the connections in offlinemode)
If that won’t work you can hand-edit the XML of the package. The way I did it was:
Close the DTSX-package,
Rename [...]
Mats Codemix Mats Codemix på kuff
