January 7, 2014 at 3:25 am
I have a simple SSIS package with a variable excel connection manager but it's working as expected. Bloody SSIS! 😀
There are two variables, SourceFolder and SourceFileName. These get updated with values from a configuration table. I have run the package in debug mode and I can see the variables are being populated as expected.
In my excel connection manager I've an expression as below:
Connection String:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @[User::TheSourceFolder] + @[User::TheSourceFileName] + ";Extended Properties=\"Excel 12.0 XML;HDR=YES\";"
However, when I run my package, it keeps using the original excel file I used to test with initially. Is there a way to view the content of the expression at run time? What am I missing here?! By the way, I also tried to use Excel File Path in my expression but I still have the same problem.
Any ideas?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 7, 2014 at 3:41 am
Sorted... nothing wrong with SSIS, was just me being stupid! 😛
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply