Viewing 15 posts - 12,676 through 12,690 (of 13,870 total)
You probably need to use a Script task to assign the text and access the contents of the variable - otherwise you'll just get the literal text in there.
July 6, 2009 at 7:04 am
OK, not quite correct for an OLEDB source.
First you need to assign the whole SQL string to a variable, then you need to change the Data Access Mode on your...
July 6, 2009 at 6:36 am
Use an Expression to set the SQL ... That will decode your variable for you.
July 6, 2009 at 6:21 am
Ah, yes, I see it now. That would require detailed knowledge of importing from XML, which I do not have, sorry:-) But, in SSIS, there's always a way ... it's...
July 5, 2009 at 7:18 pm
Your example did not appear, but you should check out the Multicast transformation to see whether it gives you what you need ... one source to multiple destinations.
July 5, 2009 at 6:50 pm
Perhaps this thread is relevant to what you are trying to achieve?
July 3, 2009 at 2:10 am
OK, this is how I think it should work - not that I've done it before - so please excuse slight inaccuracies ...
1) Create two string package variables, 'FileSpec' and...
July 2, 2009 at 7:13 pm
Surely this thread would be more likely to get a decent response in the BI forum?
July 2, 2009 at 8:35 am
Introduce an initial Execute SQL task which sets a package variable to, say, the result of running a query like this:
select count(*) [VersionCount] from table
where version = 'xxxxxx'
Then, after your...
July 1, 2009 at 4:20 am
I asked you two questions and you answered neither. So I do not know whether I am on the right track.
A Foreach container might give you what you want ......
June 30, 2009 at 8:38 pm
This is how I would do it.
1) Copy from a blank (except for column names) Excel spreadsheet file to (say) export.xls
2) Your package always exports to this new export.xls
3) A...
June 30, 2009 at 6:06 pm
Do you mean that you know that there will be a file called
filename_2006_06_30_hhmmss.xls
but that you do not know what the hhmmss bit will be? So a test for
filename_2006_06_30_*.xls
would return the...
June 30, 2009 at 5:55 pm
Using the Excel file as the source, a Script Component should be able to build the output you want. Will take some dev, but may be able to code it...
June 30, 2009 at 4:35 am
OK, great. You need two datasources (your two files) going into a MERGE JOIN transformation within a dataflow task.
From your MERGE JOIN, output to your SQL Server destination (third table,...
June 28, 2009 at 9:46 pm
What do you mean by 'selected'?
Are the tables in SQL Server?
How does this question relate to SSIS - what are you going to do with the data?
June 28, 2009 at 8:30 pm
Viewing 15 posts - 12,676 through 12,690 (of 13,870 total)