Viewing 15 posts - 9,181 through 9,195 (of 11,678 total)
Coolroof (7/14/2011)
delete from [192.21.10.34].test_DB.dbo.emp_check1 where eid in (select eid from emp_check_loc where eid=12345)
Maybe I'm missing something, but isn't your query the same as saying:
delete from [192.21.10.34].test_DB.dbo.emp_check1 where eid = 12345...
July 14, 2011 at 6:58 am
In that case I would build a dynamic INSERT statement using the metadata found in the INFORMATION_SCHEMA tables. Find all the columns for a specific table and create on the...
July 14, 2011 at 6:43 am
Is it possible to post the query?
July 14, 2011 at 6:42 am
How do you put the data in the tables?
Do you use a dataflow, an Execute SQL Task, a script task, ... ?
July 14, 2011 at 4:56 am
Nice article, thanks Tom.
Looking forward to the rest of the series.
July 14, 2011 at 4:52 am
I'm with cengland0 here. For ETL populating a data warehouse, I do not use DRI. I believe the ETL itself is responsible for the RI and using foreign keys just...
July 14, 2011 at 4:45 am
In Denali this will be easy, but for the moment you can't tell SSIS to ignore the design-time default.
You could set all the connection managers to invalid connections, so that...
July 14, 2011 at 4:33 am
This thread should point you to the right direction:
July 14, 2011 at 4:29 am
There isn't an out of the box XML destination in SSIS.
There are probably some 3rd party components out there, either paying or open-source.
Or you can create your own using a...
July 14, 2011 at 2:34 am
Phil Parkin (7/13/2011)
Of course. Set breakpoints and run interactively in BIDS.Debugging a Script Component is not so easy ...
To expand: take a look at the Locals window and the Watch...
July 14, 2011 at 2:29 am
jsquared24 (7/13/2011)
Oh and FYI the other characters besides 0-31 were 147 and 148 that caused the truncation errors. Those were the ones I was not expecting.
Well, you solved your...
July 14, 2011 at 2:28 am
I still think the problem lies somewhere else. The OLE DB Destination with Fast Load option shouldn't have too many troubles inserting millions of rows. Maybe you can try a...
July 14, 2011 at 12:59 am
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Crystal ball needed here. I forgot mine at home. 😀
I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked for!...
July 14, 2011 at 12:57 am
Excellent question. I got it wrong, but I definately learned something. And it is very useful to know how the restore will fail.
July 14, 2011 at 12:24 am
incubator123 (7/14/2011)
Thank you for reply.But in my case the destination table is already exist and i want to maintain the data already there in that table also..Please help me!!
Regards...
July 14, 2011 at 12:07 am
Viewing 15 posts - 9,181 through 9,195 (of 11,678 total)