Hi Dear Raj, Thanks a lot for your answer. I do apologize because my English is not perfect!! more details about my problem are describe below: I've got 1200 dbf files with the different names(the code or the name of branches in our bank are the same as 0197,0137,1242,..)and 1200 equivalent databases in SQL. I made SSIS packages for converting and exporting these dbf files to SQL Database and also a "For Each Loop" that Enumerates dbf files(the variable is the dbf file's name). Now my problem is to make a Parametric connection string or initial catalog that connect each of dbf files to equivalent SQL Database(with the same name) I used "Data Source=ServerName;Initial Catalog"+ @[Variable] + " ;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;" in the Properties of my connection but it's got Error. I hope, I could describe the details. Thank you very much indeed. Good Luck. Saied
What is the error message that you are getting? Just for debugging put a script task with msgbox inside the for each loop to check the variable value thats getting populated. Is the value what you expect?
hi raj, thaks alot i wrote "Data Source=ServerName;Initial Catalog="+ @[Variable] + " ;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;" in connection string but the below error is shown: " property value is not valid"
What is the connection type you are using? OLEDB or ADO? For OLEDB the conn string will be: Data Source=;Initial Catalog=;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
For ADO Data Source=;Initial Catalog=;Integrated Security=True;
Hi Dear Raj,
ReplyDeleteThanks a lot for your answer.
I do apologize because my English is not perfect!!
more details about my problem are describe below:
I've got 1200 dbf files with the different names(the code or the name of branches in our bank are the same as 0197,0137,1242,..)and 1200 equivalent databases in SQL.
I made SSIS packages for converting and exporting these dbf files to SQL Database and also a
"For Each Loop" that Enumerates dbf files(the variable is the dbf file's name).
Now my problem is to make a Parametric connection string or initial catalog that connect each of dbf files to equivalent SQL Database(with the same name)
I used
"Data Source=ServerName;Initial Catalog"+ @[Variable] + " ;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"
in the Properties of my connection but it's got Error.
I hope, I could describe the details.
Thank you very much indeed.
Good Luck.
Saied
This comment has been removed by a blog administrator.
ReplyDeleteHi Saied,
ReplyDeleteAfter the Initial Catalogyou are missing the equal to sign.
Change it to:
"Data Source=ServerName;Initial Catalog="+ @[Variable] + " ;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"
What is the error message that you are getting?
Just for debugging put a script task with msgbox inside the for each loop to check the variable value thats getting populated.
Is the value what you expect?
hi raj,
ReplyDeletethaks alot
i wrote "Data Source=ServerName;Initial Catalog="+ @[Variable] + " ;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"
in connection string but the below error is shown:
" property value is not valid"
What is the connection type you are using?
ReplyDeleteOLEDB or ADO?
For OLEDB the conn string will be:
Data Source=;Initial Catalog=;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
For ADO
Data Source=;Initial Catalog=;Integrated Security=True;
I think this could be an issue.
I found it dear Raj;
ReplyDeletei wrote it in expression
and it works good
what was the issue?
ReplyDelete