Viewing 15 posts - 11,731 through 11,745 (of 13,849 total)
And the problem you have is just with the 2005 database, or with both? Are your db's both set at 90?
November 23, 2010 at 5:58 am
Where is the SSIS package running? On 2008 or 2005? I would expect it to work if using a 2008 package (though haven't tried it).
November 23, 2010 at 3:55 am
SSIS does not natively handle dynamic column mapping in dataflows, if that is what you are referring to?
November 23, 2010 at 3:16 am
Haha 🙂
Rather than emptying an existing Excel file, you may find it easier to have a blank 'template' file available somewhere on the network which contains only the headers you...
November 22, 2010 at 1:41 am
mklein2 (11/22/2010)
For Oracle I use an OLE DB connection. This is OK. But after I have to do an other Lookup with an ODBC connection....
November 22, 2010 at 1:22 am
wannalearn (11/19/2010)
By the way I have that sp_senddbmail in sql statement too. I tried it. It's still not working
If I told you that my car was 'not working', would you...
November 19, 2010 at 9:46 am
That is a warning only, not an error and should not cause the step to fail. Are you sure that you provided all of the message text?
November 19, 2010 at 8:46 am
da-zero (11/19/2010)
badam.manoj (11/19/2010)
Hi Phil,Thanks for your response
you left me no choice.. I'm creating 4 dataFlow tasks now
suggest me if there is any other approach which makes it easier
You...
November 19, 2010 at 8:03 am
To do it more elegantly requires a dynamic dataflow task, which is not available out of the box.
You may find that this gives you a better and more scalable solution...
November 19, 2010 at 4:00 am
Unless the tables are the same in structure (field names, types) and have exactly the same destination (table, field names), you'll need four separate dataflow tasks anyway.
If that's the case,...
November 19, 2010 at 2:46 am
My answer will provide roughly as much detail as your question.
Yes.
November 11, 2010 at 10:40 am
Accepted good practice is to move a file which has been processed to a separate archive folder - then you don't get a mixture of processed and unprocessed in the...
November 11, 2010 at 8:48 am
Could you have a task that runs first which renames the file, dropping the h:m:s bit and then feed that into your dataflow as normal?
November 11, 2010 at 8:23 am
Well I'm sorry [BigGrin] (but I did post it before you [Smile] )
Yeah I know. I was in full artistic composition mode while you nipped in and posted a...
November 9, 2010 at 2:35 am
da-zero (11/9/2010)
November 9, 2010 at 12:35 am
Viewing 15 posts - 11,731 through 11,745 (of 13,849 total)