Viewing 15 posts - 12,691 through 12,705 (of 13,876 total)
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
That's quite a long post and I did not read it in detail. But I think I get the gist.
The way I would do this is to maintain your ExternalID...
June 27, 2009 at 9:09 am
Here's a VB.NET function that you could adapt:
Public Function GetLongDateSQLFormat(ByVal data As Date) As String
getLongDateSQLFormat = ""
getLongDateSQLFormat = Format(data, "yyyy-MM-dd...
June 26, 2009 at 8:39 pm
Log in to the server using Terminal Services and run it there ...
June 25, 2009 at 8:35 pm
In the editor for the flat file connection, what are the datatypes for the input columns?
June 25, 2009 at 6:30 pm
Your original post did not suggest any reason why you would need to use a conditional split - can you describe why you are doing this?
You talk about 'dragging' from...
June 25, 2009 at 6:26 pm
Here is one way.
1) Create a package variable - UserID
2) Modify your ExecuteSQL task so that the result of the query is mapped to UserID.
3) Add a Derived Column transformation...
June 25, 2009 at 5:51 am
I was not really any help at all, to be honest - I just asked a lot of (probably) annoying questions 🙂
Here's my point: if a date from another system...
June 25, 2009 at 5:44 am
But when I asked you what the datatype of CREATEDTS was, in SSIS, you said Date.
How can it ever work? It will fail before you even get a chance to...
June 25, 2009 at 4:53 am
I do not think that 1/1/0001 is a valid date in SSIS and that may be causing some issues for you.
I just tried to create a derived column as follows:
(DT_DATE)"0001/01/01"
but...
June 25, 2009 at 1:52 am
Viewing 15 posts - 12,691 through 12,705 (of 13,876 total)