Viewing 15 posts - 12,826 through 12,840 (of 13,849 total)
What is the format of the dates in the source file? Please post an example.
May 1, 2009 at 8:29 pm
Wow, felt like I was downloading a movie as I was waiting for that huge screen-shot to appear 🙂
There is a very strong suggestion that there is a problem with...
April 30, 2009 at 6:53 pm
One way of making this work is to have a template spreadsheet somewhere, which contains no data, but only the column headings/sheet names. Then your process would be:
a) Delete orig...
April 30, 2009 at 6:21 pm
Sounds correct, except (hopefully) the rows that you are removing are 'matching', not 'duplicate'.
The 'Upsert' idea, though slightly more complicated, should perform better, as it requires much less disk activity....
April 30, 2009 at 6:05 pm
What does the package do?
Can you paste the detailed error message?
April 30, 2009 at 5:43 am
Is there a 'Date Last Updated' field on the Oracle data? If not, can you add one?
Initially, you will have to load all the data, but after that, just select...
April 30, 2009 at 5:39 am
Easy. Create a new 'parent' package.
In that, string together your already developed packages as a series of Execute Package tasks.
Running the parent package will then execute all of your 'child'...
April 30, 2009 at 1:56 am
So you are trying to add a copy of an existing column to an existing table?
This sounds like a one-off design task - why are you thinking of using SSIS...
April 29, 2009 at 11:55 pm
Cralis (4/29/2009)
Error: 0x0 at Check Vehicle Mappings: No result rowset is associated with the execution of...
April 29, 2009 at 11:49 pm
Pretty much - you're on the right path! Start running it with some test data and seeing what happens ... the best way to learn.
I would use Expression and Constraint,...
April 29, 2009 at 11:37 pm
Please confirm that you have tried changing the error row disposition to RD_RedirectRow? The error message strongly suggests not.
April 29, 2009 at 11:31 pm
Sorry 😀
Please explain in more detail what you are trying to do - it is unclear from your original post - and I will attempt to describe how it might...
April 29, 2009 at 11:24 pm
OK, I changed my mind - let's do it your way after all, as you do not need the staging table data for other reasons.
Create the variable as I mentioned...
April 29, 2009 at 9:35 pm
Try here:
http://www.jumpstarttv.com/loading-binary-files-into-sql-server-using-ssis_62.aspx
Registration is free.
April 29, 2009 at 9:05 pm
Viewing 15 posts - 12,826 through 12,840 (of 13,849 total)