Nice basic question. thanks for sharing. I assume SQL SERVER default setting discussion wont come in for this QotD but who knows. 🙂

try to place the packages on another driver like D,E etc and execute the dtexec Utility again. as per error it is a security issue. as dtexec unable to read...

have you verified the amount of data for each date your are comparing these result?

Lets Say Date1 01-Feb-2014 have 120,000 rows

and Date1 01-Jan-2014 have 12,000 rows

something like...

i can understand what kind of dilemma you are in right now. its great you want to know which is active db or not. If its a office environment, and...

nice suggestion Eirikur. but my unstoppable urge for asking from OP is WHY 🙂

Where is you package is located ? if its exists on the application server, then try to run this package manually on that server.

if the package run successfully, and fail...

for a second i thought i was the only one 😛

+1

Thanks, i forgot to mention that in my answer 🙂

1) For Describe 'TableName', In SQL SERVER you can use sp_help 'Table Name'.

2) For dba_views, In SQL SERVER you can use select * from INFORMATION_SCHEMA.TABLES.

Ans:...

whats wrong with the option 1 exactly?

you can do it in two ways on your preference

1) Import the data into a newly creating staging table using FLAT File Source, simple fetch an dump in the database....

Nice and easy. Thanks for sharing

Nice question, thanks for sharing