That was the problem. Thanks!

I was afraid of that. Thanks for your help.

I was able to parse everything into its own column using the comma as the delimiter and I was also able to use the select I posted earlier to get...

To create an SSIS project, you need to use the Business Intelligence Project type in Visual Studio. Make sure you have selected Business Intelligence Projects under project types and then...

Are you creating an Integration Services project in Visual Studio?

Using SSIS you would use the Data Flow Task and then on the Data Flow tab, create an OLE DB...

I just want to clarify my previous post that even if the new database wasn't in SQL Server, you could still use SSIS for data transformation using the Ole DB...

Is the new database in SQL Server? This sounds like a job for SQL Server Integration Services (SSIS). You can export the data from both the old SQL Server database...

Thanks for your reply. I was wondering about moving the parameters around because my Google searches weren't providing any solutions. Your solution will do the trick.

Thanks!

Hi Deepak,

I got it to work as you mentioned by keeping the job owner sa and then giving the necessary permissions to the directories to the SQL Server Agent service...

Were you able to figure out what the problem is. I'm receiving the same error and my variable is a read only in the script task.

Error: 0xC0014054 at Script Task:...

I was able to fix my problem by doing the following:

exec sp_removedbreplication 'dbname'

Backup the log file

Execute DBCC SHRINKFILE

The log_reuse_wait_desc now says 'NOTHING' and I was able to shrink the log...

Yes, I did. I don't really understand what's going on here, but I did find these posts. Although it seems that the bug they're referring to was happening in RTM...

When I execute that stored procedure, I get the following message:

Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 1

Unable to execute procedure. The database is not published. Execute the...

Unfortunately, we do not know how long this corruption has been there or what caused it. The most recent backup that we used to restore also had corruption and we...

Hi Sugesh,

Thanks for the reply. I noticed that I had to run dbcc checkdb with the repair options but then the db has to be put into Single User Mode....