Q & A - Integration Services Questions

connect exe to ssms pinn database while install in other pc

exe.config, exe,database available after instal ssms in other pc unable to connect to database from exe to database, exe opening, database opening in sql server, but in exe login form user not showing , means data not showing, kindly help to connect it

ODBC connection excel VBA to Snowflake connection string needed

Need to connect excel VBA to snowflake. Can anyone provide a connection string for that?

SSIS Package Encrypt password in IBM DB2 Conncetion string

Hello There, I have created an ssis package which pulls the data from IBM DB2 to a SQL table. To connect to DB2 i was using a project parameter DB2_ConnectionString as below

Password for ODBC Connections

Hi everyone I´m working with Visual studio data tools to create a DTSX that will work in SSIS. when I create the ODBC Connection I need to write a USER and PASSWORD for this connection but the password is not persistent.

DTEXEC override Teradata Connection

I am executing SSIS packages that override the Connection string by submitting new connection parms from batch execution of the package using dtexec.

the variable _ConnectionString was not found in the Variables Collection

Hi, trying to create a SSIS flow to extract data from source (AS400) to destination (SQL) db. The flow is relatively easy: connect, extract and put it in destination folder.