Viewing 15 posts - 13,006 through 13,020 (of 13,841 total)
So your field delimiter is a semicolon - sorry if this is obvious, but did you define this as your field delimiter in SSIS?
Can you post a couple of lines...
January 5, 2009 at 7:55 pm
I have a piece of VBScript that will do the folder flattening for you ... but I guess that's not allowed, being dynamic.
Can't find any Windows command to do it...
January 5, 2009 at 8:05 am
Ninja's_RGR'us (1/5/2009)
Well step 1 in any etl is EXTRACT.So I'd put all that data into temp table then I'd start the transform tasks. Then my query would easily work.
Right...
January 5, 2009 at 7:54 am
Do you want to process the rows in ascending date order?
If your source has rows 1, 2, 3 and 4, what will be in your calculated table?
Will it be
1-2
3-4
or
1-2
2-3
3-4
?
January 4, 2009 at 11:38 pm
Please describe what you mean by 'difference'.
Eg, if
row a contains: 'Fred', 12, 1980
row b contains: 'Bill', 150, 27
what would the difference be?
Also, what order are your rows in?
January 4, 2009 at 10:17 pm
Sanjay (1/1/2009)
HiHow to add multiple XML results set in SSIS. i tried to add through he UI. it is added also, but i am getting error that
...
Sanjeev
Please explain...
January 1, 2009 at 11:14 pm
Create an OLEDB connection to your database.
Add an Execute SQL task - specify the above connection.
Click on Expressions in the task editor and then expand the Expressions item to get...
December 28, 2008 at 9:56 pm
The ALTER TABLE requirement continues to puzzle me. Anyhow, now that I understand better what you are trying to achieve, here is how I would do it:
1) Create a staging...
December 26, 2008 at 7:54 pm
I am afraid that I do not know about your error message.
But I have never found anything in an ActiveX task that cannot be accomplished in a script task and...
December 23, 2008 at 7:46 pm
It's no mystery - you have to rewrite your code using .NET syntax. I'm afraid that you have some learning to do, as I doubt that people here have the...
December 23, 2008 at 7:33 pm
You need to rewrite your VBScript code in VB.NET - the syntax and commands are quite different. I'm afraid that cutting and pasting just won't work.
Phil
December 23, 2008 at 7:23 pm
Can I just confirm what the underlying business requirement is here? Is it that there are constant amendments to an Excel spreadsheet of employee data and you want these amendments...
December 23, 2008 at 7:15 pm
And, what order might that be? Order by name, date, extension, 8.3 name, or ???
haha, I was wondering the same and was hoping to draw out the answer gently,...
December 23, 2008 at 7:06 pm
Great tip - I did not know about that ... looks perfect for this.
December 23, 2008 at 6:16 am
Viewing 15 posts - 13,006 through 13,020 (of 13,841 total)