Im sorry its a typo.. I just replace the names on word editor.. the first 2 queries will be like this:

-- it will insert the id on Table1 if...

What is the deal with table1? Is this a temp table, table variable? What are you trying to accomplish with it?

Table1 is a phisycal table, I need to...

Thank you so much John.. This is my tored procedure:

Let me know if that makes sense and how i can do it on my SSIS... 🙂

-- insert ID into a...

Actually is for my boss. He doesnt want to run a Bulk Insert with SQL. He prefers to run a dtexec package to use PC resources instead of SQL.. I...

What do you think John

Thank you Paul,

I need to query and load data faster. I have read about partitioned tables to load data into that table that has millions of records..

What to...

This is the way i want to do it now...

Right now we have a Bulk insert procedure on a stored procedure.

It takes around 120secodns cause the table is not...

A couple questions for you:

1. Does your table have a clustered index on it? If so, what column/datatype?

2. Why load the data twice, once into a staging table, once into...

Im sorry for the question.. How I do check that ?

thank you

In my PC says:

Microsoft SQL Server Integration Services Designer

Version 9.00.4035.00

in the Server when I need to run the utility says:

Microsoft SQL Server Integration Services Designer

Version 9.00.3042.00

Its created in Visual Studio 2005. But, Since I tried all the solutions posible. I guess I have conflict with the system files version on the computers.. How can I...

Thank you so much for your respond.

This is the situation. My PC has installed SQL 2005 and Visual Studio 2008. The Server where I want to run the package...

Any advice in how to run it either as a SQL Agent Job or using the DTexec Utiliy ??

Thank you So much

i tried to copy this code in my first message but it didnt appear cause the tags.. This is my Configuration File.

DTSConfiguration

DTSConfigurationHeading

DTSConfigurationFileInfo GeneratedBy="User" GeneratedFromPackageName="SSIS" GeneratedFromPackageID="{4137D44F-A958-4268-8180-F6D5172B7BCB}" GeneratedDate="7/24/2009 12:06:40 PM"

DTSConfigurationHeading

Configuration...

I found it.

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