Viewing 15 posts - 1 through 15 (of 59 total)
That was the problem. Thanks!
September 23, 2009 at 9:51 am
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...
January 30, 2009 at 1:06 pm
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...
October 15, 2008 at 8:38 am
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...
October 10, 2008 at 2:33 pm
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...
October 10, 2008 at 1:02 pm
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...
October 10, 2008 at 8:29 am
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!
October 9, 2008 at 8:05 am
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...
July 31, 2008 at 12:27 pm
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:...
July 25, 2008 at 3:45 pm
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...
June 2, 2008 at 11:11 am
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...
May 30, 2008 at 4:14 pm
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...
May 30, 2008 at 3:58 pm
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...
February 29, 2008 at 7:38 am
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....
February 28, 2008 at 8:44 am
Viewing 15 posts - 1 through 15 (of 59 total)