I don't think you can use Fast Load in this case.

CEWII

IS the user account being used to install this an admin type account in XP?

You might look at this:

http://social.msdn.microsoft.com/Forums/en-US/sqlnotificationservices/thread/7d349834-46dc-476f-9ba0-4c7690b6e01a

CEWII

You're probably not going to like it though..

You can use a script task as a data-flow data source, you read the data directly and map it into the columns you...

The first thing that comes to mind is using the Import/Export wizard and saving the package which you can edit later.

CEWII

I think you can actually look at the DTSX file and find them but it is a hassle.

There is a component on CodePlex that will do this for you:

http://eod.codeplex.com/

CEWII

No, I haven't run accross this specifically, but I can see your logic and agree. You might report this as a defect on http://connect.microsoft.com and see what they say.

CEWII

Great, good to hear it, can you tell us what it was?

CEWII

swendrich (6/29/2010)

---

yes i have considered the import/export wizard.

But you are right. The problem is to create the structure in the mdb file.

I think, i can do a SELECT COLUMN_NAME...

You can find out what security context of SQL by doing this:

EXEC master.dbo.xp_cmdshell 'SET'

Near the bottom you should see:

USERDOMAIN=SQLsLoginDomain

USERNAME=SQLsUserName

If you see neither of those then you might not have gotten...

I like to make my processes pretty bullet-proof when I can.

I believe Spencer wrote about checking the max id, that method may work, provided the data always deletes everything below...

I think the problem you'll find is you still need to add the structure to the MDB file, creating the file is nothing, the dataflow has to have something to...

I...

I am going to agree with Lowell, start with those suggestions.

I am also thinking his original suggestion is a possibility, if for any reason the exe throws out...

Not really automatically, but if you already have the structure of the tables in a database (ie you are copying column for column from existing source) you can generate the...

Is it defined as a .net connection or an OLEDB connection, if it is the latter then the code will not work, you have to define the connection consistent with...