- Posts: 12
- Thank you received: 1
Invalid connection string attribute
4 years 7 months ago #21476
by ae
Invalid connection string attribute was created by ae
Hi
AETLE 6.3.7.18
SQL Server 2017
I have created a connection to a SQL DB using a username/password combination. Clicked Test and it says connected.
I have used this connection in a transformation which reads data from 2 tables in that DB. This works fine and outputs the data as I want it to.
The issue I am having is with a subsequent step in the process where I want to create a SQL script which updates one of the tables in that DB. When I create a SQL Script and use the same connection I always get the error "Invalid connection string attribute" when I try to run any SQL - even just "select 1".
Any idea why the connection would work in a transformation but not in a SQL script?
Thanks
AETLE 6.3.7.18
SQL Server 2017
I have created a connection to a SQL DB using a username/password combination. Clicked Test and it says connected.
I have used this connection in a transformation which reads data from 2 tables in that DB. This works fine and outputs the data as I want it to.
The issue I am having is with a subsequent step in the process where I want to create a SQL script which updates one of the tables in that DB. When I create a SQL Script and use the same connection I always get the error "Invalid connection string attribute" when I try to run any SQL - even just "select 1".
Any idea why the connection would work in a transformation but not in a SQL script?
Thanks
