Tried that but of no use. 🙁

How can we check the service account under which Sql agent runs?

I am having a flat file as a source that loads the data to the table. The same...

Servers are same. the configuration file is in form of a database table.

I have deployed the package also on the server. the deployed package also runs fine whren ran...

Ya. The data can be viewed when we preview through the connection manager. The file location is also correct.

There seems to be some other problem with it.

File is present at that location. Have checked it again.

Thanks,

The credentials are correct and the access is also there.

Managed it through small piece of code in script task.

thanks a lot.

I am able to manage it through script task.

thanks so much.

the suggestion helped. Thanks a ton.

I just want to update my table for the records having NULL value in the newly inserted columns. any way is ok as long as the table is getting updated...

Thanks. Got the solution.

In that case i will 2 options to choose all the values. One that i will insert explicitly and one provided by the reporting tool.

Is there any way to have...

I am trying to import a csv file to a database table thru SSIS. In the file we have one date column and i have explicitly converted it to datetime...

hey. the problem got resolved.

FINDSTRING function worked. requried some casting to be done to make up for the incompatibility between the data types.

thanks a ton for ur help.

Hey, thanks.

the FINDSTRING this worked. but the conditional operator condition is still raising an error.

The error is: 'Incompaible types for operator " != ". It needs to be...