interesting question. thanks for sharing

good question, thanks for sharing.

nice question. never used this one but yet again learned a new thing. Thanks for sharing

nice question, thanks 4 sharing.

I think you need to share more details regarding your package.

As per my understanding, if you have Jan-2014 data in a table. And now want to upload the data of...

if you remove the DELETE functionality from your ssis package, data will be appended in your table without any issue.

great. what hidden character?

hmmm .... What is the data type of variable SiteName. furthermore, how many columns are there in derived column transformation beside SiteName?

you just need an additional INT data type Variable...

Nice question to end the week.

Incorrect answers percentage = 53 % , I hope its count() is working properly 😛

ok try this

1) create a copy of the package which is giving error on your dev environment.

2) Remove the OLE DB Destination.

2) Replace the Derived Column Customer with Rowcount. can...

As far as i can understand your delete package is running because the source and destination is RDBMS(MS QL SERVER) but in the package you are having issue you have...

okay, you are using ADO.Net source.

which type of source your are using oracle/access/PostgreSQL ????

diversion.dummy (1/22/2015)

---

The delete package executed successfully through dtexec as administrator.

The others gave me the same error as before, unfortunately:

OnError Data Flow Task Customers,{25CD0553-6250-4448-AAD3-E011CE618292},{0710E248-236C-47B8-A19F-2466DF32282C},22/01/2015 10:12:41,22/01/2015 10:12:41,-1073450900,0x,Component "Derived Column Customers, clsid {49928E82-9C4E-49F0-AABE-3812B82707EC}"...

Koen Verbeeck (1/22/2015)

---

Got this one wrong. I was thinking NULL would be counted as a distinct value, and I realized too late I was confusing it with unique indexes.

Ah well,...

try to open the cmd.exe as administrator on the server and then execute statement you have mentioned earlier.

However, When you run the dtexec utility its run under the current user...