Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Developing SSIS packages locally using BIDS

We develop our SSIS packages in BIDS locally using Visual SourceSafe for version control. The packages are then deployed on the server where the databases reside.

My question is: Can DBAmp be used as a Connection Manager in this case? It doesn't appear in the list of OLE DB providers in BIDS on my local machine. We have installed the 32-bit version of DBAmp on the server where the package will be deployed and it is working properly there.
1 person has
this question