Viewing 15 posts - 76 through 90 (of 130 total)
Thanks Phil!
You are never to old to learn something new. I didnt even know about the now.date
February 21, 2011 at 5:20 am
For me personally, the bulk insert would be a bit of an overkill. I load daily data and somedays I would have to load upto a 10 million records, but...
February 17, 2011 at 4:03 am
I use bulk inserts only on tables with more than 10 million rows. SSIS handles the data import quite well I there is only 1 case where I use bulk...
February 17, 2011 at 12:55 am
Craig Farrell (1/31/2011)
In T-SQL, you'll build a staging table that holds all of the columns/rows
Out of the 20 odd SSIS packages I'm in control off, 2 of them uses this...
February 17, 2011 at 12:08 am
What I do in my packages if I want to update the data in the table which I read in already, is to use
a SQL Task, where I call...
February 8, 2011 at 2:32 am
Ok, not large scale but I developed and maintain a 550 gig datawarehouse database, got 1 table with close to 900 million records, and anothers with 600 mil, 400 million...
January 14, 2011 at 2:13 am
"We are now using template file to replace if existing..As I don't think we have option to truncate the data.."
With SSIS and Excel as destination file, I found that you...
January 6, 2011 at 10:54 pm
Just to add, seeing that the original question was about reading in CSV file, I’ve got a scenario where I need to read in txt files from the cell phone...
January 6, 2011 at 10:35 pm
Just to add. I have about 30 project all about the same, all of them reading Falt files into the Warehouse. I go into Windows Explore and copy and paste...
January 6, 2011 at 10:21 pm
If i need to do some serious coding, I put on the headphones and some nive heavy metal or something similar.
I'm in a open plan office and there can be...
December 3, 2010 at 2:09 am
The package is just a XML file, open it up in any test editor. I use Textpad for this.
For instance the reason I do the manual edit of the file...
October 21, 2010 at 5:31 am
Ok, it was just a quick reply I must admit.
I only now see that you found you solution already.
But to add, I had a problem with the Bulk insert (cant...
October 21, 2010 at 4:37 am
I had the same problem and I think that it is a bug in SSIS.
When you select the table to be populated in the drop down list in the OLE...
October 21, 2010 at 3:36 am
Hi Phil, sorry about that, but yesterday was mad and I really needed a solution thats why the post.
But if I just used the correct terms......Something I've always struggled...
May 6, 2010 at 4:56 am
Viewing 15 posts - 76 through 90 (of 130 total)