Hi again,

I got it working...The link in your last reply helped me a lot!

Thanks a lot again!

😉

How about this link ?

https://picasaweb.google.com/lh/photo/NVtWwU5TG8grxcUtw1YSgNMTjNZETYmyPJy0liipFm0?feat=directlink

I did as on the image, but when Script task complete, it stops, it does not go to execute sp_BulkInsertImportedData Task.

Any reason?

Good point, I accidentaly submited my post before i was finished. now It is ok ! 🙂

Thanks for helping !

I got it now. from this link -->

Yes I did get this resolved. It is kind of an ugly work around. The error is because I am getting prompted...

Hi ,

To run the SQL job, I use NT AUTHORITY\NETWORK SERVICE account but I do not know the password for it.

I tried with a blank password but that did not...

Hi,

I have tried both suggestion and still the same issue.

I tried adding \\blmcik to the trusted sites list and enabled the option "Launching applications and unsafe files"

I replaced...

Finaly, runnnig from an SQL job, it hangs, waiting for a click to a security warning message I guess.

Did one of you successfully ran pscp.exe from a vb script task...

HI ,

I finally changed the way I was trying to get it done.

So instead of writing a .bat file with the PSCP.exe command lines, and then run that .bat...

I tried the not to use the execute task but running it on the server, I was getting a security warning pop up window. So I figured out that was...

I found the error...

In my code I have the following line...

If CBool(InStr(LigneLue, DateTime.Today.AddDays(-1).ToString("dd/MM/yy"))) <> 0 Then

write someting..

But that condition was never met because the server was still looking at a...

Hi,

Using the following , If the column value is negative then I display -1 else I want do the sum on that column.

case

when CAST(Data1 AS Int) < 0

...

Hi,

I received another suggestion that works actually.

I use comma as the field terminator, and then I remove the wrapping single quotes after the import into a staging table.

Thanks for...

Hi all,

I apologize, the solution suggested by Wayne is working fine.

I made a mistake with that part of the solution (t.Code, ',') ds.

:Whistling: