In my ssis package, I'm specifying the name of my database via a variable, called @DatabaseName. When I go to open this connection via a Data Flow Task however, I receive the following error:
[SSIS.Pipeline] Error: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
I have a sql connection manager (which I named "DynamicDB"). In my connection manager's properties, I added an expression for the "ConnectionString" property, with the following expression:
"Data Source=<My_Server_Name>;Initial Catalog="
+ @[User::DatabaseName] + ";Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;"
So far so good, but when I run it, I get the error I mentioned, somewhere in my Data Flow Task. Within my task, I have an OLE DB Source, in which I set the connection to the name of my sql connection manager ("DynamicDB").
Any idea what I'm doing wrong?
Thanks