Hi, I execute the sp in VB just like you are saying, the only different that I see is that the string is different I used it like this:

strCadena =...

Thanks for your help, but I have some doubts, I am not an expertise on this, so how do I put it in a sp?

and I try to found the...

Thanks for the tip, but I have some questions:

1. I have a column on my xls thata has different type of data, and when I run the DTS the...

Thanks Steve, I try to make that and see what happens.

how many "services" can be running on the server?

Guys you´ve been great, I am beginning with this and...

Thanks Antares for the tip, I will find out more about thee things you are telling me.

About the error is kind of Network error, call your administrator, or something like...

Thanks Steve for your quick answear.

What do I do o r make to see if it is network issue?, what can I recommend them to do?

Yes I...

Hi Steve thanks for answering.

I would like to try all of them and see how it works each one, and I can learn more things doing this.

The first point I...

Hi, I had the same "problem" and I did this:

CREATE PROCEDURE spExample

@namevarchar

AS

DECLARE @strSqlvarchar

DECLARE @tablevarchar

Set @table = 'TableName' + @name

Select @strSql = "select * from ' + @table

Exec (@strSql)

I hope I...

Hi to all, guess what. I was trying the bcp, with the example that nigelrivett send. First I was having errors, I was documenting them but finally I...

Hi, I try what you told me:

master..xp_cmdshell

''bcp Integra.dbo.temp_Reporte_shpmnt in F:\Cerveceria\adw_39_FPP\Sp\MasterPlanning\enterprise\scp\data\solver_data\op_data\Shipment.sol /U user /P password /S server /c /t","''

but I received this message...

output

---------------------------------------------------------------------------------

SQLState = S1000, NativeError = 0

Error = [Microsoft][ODBC SQL...

Hi, someone told me that the user need a sysadmin profiles or soomething like that, to do a bcp or a bulk insert.

Thanks 😀

Ana

Sorry Steve, I thaught that my post didn´t arrive, because my connection failed.

😀 please sorry I didn´t mean it

HAve a great day

Ana

Thanks Steve. Here is the sample:

Mosto_Boh,,P_Mty,ELABMTY1,,1997-09-01,3600,3600,3600,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Boh,,P_Mty,ELABMTY1,,1997-09-15,3200,3200,3200,0,I,,,100.000000,0.000000,0,0.000000

Mosto_CB,,P_Mty,ELABMTY1,,1997-09-01,60600,60600,60600,0,I,,,100.000000,0.000000,0,0.000000

Mosto_CB,,P_Mty,ELABMTY1,,1997-09-08,70700,70700,70700,0,I,,,100.000000,0.000000,0,0.000000

Mosto_CB,,P_Mty,ELABMTY1,,1997-09-15,10100,10100,10100,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Light,,P_Mty,ELABMTY1,,1997-09-01,3400,3400,3400,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Light,,P_Mty,ELABMTY1,,1997-09-08,3400,3400,3400,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Sol,,P_Gdl,ELABMTY1,,1997-09-01,1500,1500,1500,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Sol,,P_Gdl,ELABMTY1,,1997-09-08,1500,1500,1500,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Sol,,P_Mty,ELABMTY1,,1997-09-01,7800,7800,7800,0,I,,,100.000000,0.000000,0,0.000000

Mosto_Sol,,P_Mty,ELABMTY1,,1997-09-08,18200,18200,18200,0,I,,,100.000000,0.000000,0,0.000000

22,P_Mty,280,CAMION1,1997-09-01,1997-09-01,2794,2794,2794,0,A,P,,100.000000,1.000000,0,0.000000

22,P_Mty,340,CAMION1,1997-09-01,1997-09-01,969,969,969,0,A,P,,100.000000,1.000000,0,0.000000

22,P_Mty,350,CAMION1,1997-09-01,1997-09-01,247,247,247,0,A,P,,100.000000,1.000000,0,0.000000

22,P_Mty,390,CAMION1,1997-09-01,1997-09-01,2538,2538,2538,0,A,P,,100.000000,1.000000,0,0.000000

22,P_Mty,400,CAMION1,1997-09-01,1997-09-01,1400,1400,1400,0,A,P,,100.000000,1.000000,0,0.000000

Ana

Thanks Steve, I don´t know what is wrong, I try to rewrite the query the part that I had the problem. Than I had to pass the DB to...

Hi steve, I made the sp_recompile with the SP, but it took only 37 minutes. So I compare the data sets, and on the previous weeks we were working...