Awesome article, it's absolutly amazing, one problem though.... I'm already using it.. 🙂

The issue here is the following.

I need to insert two rows at the begining of the table...

This is absolutly amazing. There are some huge advantages to using CLR to export to excel. One of the issues you will run into whether using open row set or...

Hey, hope that it works for you, sorry I couldn't be more help. 🙂

Yeah, use and XML source and link each node up to a seperate OLE DB Destination. These can point to the same table; however, there needs to be a destination...

No problem, I'm glad I could clarify, and thanks for the advice grant, I appreciate it. If you want to learn more about data modeling check out amazon for data...

Can you post the Query and a sample of the data pulled? I think I see what you are asking, have you tried a select into clause?

Thanks,

Bradley Jacques

No need to apologize. I just want to get this right. I had actually setup the Sales Order table so that it was dependent on the CustomerAddresses not the...

Here is a great site with some suggestions for using XML as a data flow destination in SSIS.

http://consultingblogs.emc.com/jamiethomson/archive/2006/07/11/4209.aspx

Can you post the CREATE statement for the tables referenced in the query? Just right click on the table in management studio and click SCRIPT TABLE AS->CREATE TO-> New Query...

1. Should the field in the Sales Order table be dependent on the CustomerAddresses table or the CustomerAddressesXref table?

2. If it should be the CustomerAddressesXref table should I add an...

1. CustomerAddressesXref table

2. Yes

Looks like you need to run the windows installer cleanup utility (not spyware I swear :-))

You can download it from microsoft here.

http://support.microsoft.com/kb/290301

Here is a forum where...

Hi!

I'd love to help you, can you post the create table statements for the tables you will be using with this query? I've posted what I feel is a correct...

Thanks for the answer mark, here's an example with a table create and some values.

create table TEST

(

size1 int

)

insert into test values (1)

insert into test values (2)

insert into test...

Here's a great article on an introduction to powershell for the DBA.

http://www.mssqltips.com/tip.asp?tip=1680

Thanks,

Bradley Jacques