January 11, 2018 at 6:09 am
Hello guys,
This is my first post in the forum, i'm faily new at SSIS and i've made my first packages and they are working fine but now im trying to make the folders dynamically,
For example right now im trying the next
"C:\Users\lilith\Desktop\ssis\directory\file.xlsx"
There i have the directory created and inside the directory its the file that's gonna be populated with data, its working fine so far.
Now is the one im trying to do.
C:\Users\lilith\Desktop\ssis\(this directory is supposed to be generated on runtime)\Excel template.xlsx"
the idea is the next,
1) i create the folder in the next path C:\Users\lilith\Desktop\ssis\december 2017\ , the result should be Directory Named: December 2017
I get the folder name by the next method: i connect to the SQL Server, run a query and save the query on a variable which will be used for the folder name.
Then i try to copy the template from one directory to another it should look like this = C:\Users\lilith\Desktop\ssis\december 2017\exceltemplate.xlsx
but whenever i try to run the error comes up:
This error is thrown by Connections collection when the specific connection element is not found.
I've tried to put delay on runtime everywhere but isn't working, it wont even run, saying that he can't find the connection, everything is made on runtime yet its not working.
Note: Using SQL Server Business Intelligence Development Studio 2008
January 11, 2018 at 1:49 pm
My guess is that the "DelayValidation" property is set to False on either the connection manager, package or data flow task. If you're setting the folder/file properties during runtime, you should have the "DelayValidation" property set to True on all the relevant components in your package.
January 12, 2018 at 7:24 am
Yeah. i've been using the delayvalidation everywhere but still, i think i'll just re-create the project from scratch and try to organize variables more and that kind of stuff and make the project the correct way, its just that the project requirements had and scope and now we found a way to improve it more, but its just like adding some kind of patch on the project, i'll just start from scratch with the new requirements.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply