Viewing 15 posts - 16 through 30 (of 95 total)
keywestfl9 (8/13/2010)
August 13, 2010 at 12:54 pm
Suresh.Utham (8/13/2010)
I've deployed a package in SQL 2005. When i try to execute, it's getting following error without any subsequent processing.
ERROR - SSIS package <<<Package Name>>> failed ERRORLEVEL(-1073741819)
When...
August 13, 2010 at 12:49 pm
tripower (8/13/2010)
August 13, 2010 at 12:35 pm
river22_34 (8/13/2010)
Will this command work if I am in another database for ex, If I am in "SQL_Training" database will it get executed in this database ? or do i...
August 13, 2010 at 9:12 am
river22_34 (8/12/2010)
I am getting this message when i executed this SP by using xp_cmdshell
"Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object...
August 13, 2010 at 8:46 am
tripower (8/13/2010)
August 13, 2010 at 8:42 am
river22_34 (8/12/2010)
Hi,can you also provide me the code on how to call dtexec in a stored procedure and run it using xp_cmdshell command . The entire code ?
I found this...
August 12, 2010 at 12:34 pm
river22_34 (8/12/2010)
Hi,Thanks for your prompt reply.
Could you provide me the steps on how to do this in SQL Server agent ?
1. Connect to the sql server database engine from where...
August 12, 2010 at 12:24 pm
Once you change or edit the config file, and then copy it up to the SSIS server, you need to remove and add the file back into the SQL Job,...
August 12, 2010 at 12:18 pm
river22_34 (8/12/2010)
In regards to running the SP, here's how i plan to do it.
- I can update or insert any row in the excelsheet and then save it.
- Next I...
August 12, 2010 at 11:52 am
AndrewSQLDBA (8/12/2010)
August 12, 2010 at 9:56 am
set @sql = ''
set @sql = 'exec C:\Documents and Settings\varunj\My Documents\Visual Studio 2008\Projects\Integration Services Project2\Integration Services Project2\Package.dtsx'
--exec (@sql)
You can't run the SSIS package using exec command....
August 12, 2010 at 9:44 am
sql_freak (8/11/2010)
I am new to SSIS
Current situation in company
They have SSIS packages which are already been deployed in production server, But 2day we found one package in...
August 12, 2010 at 8:40 am
Phil Parkin (8/11/2010)
But if the table doesn't exist at design time, you can't create the dataflow.
have done data population dynamic using DTS... We pulled the column info using systables from...
August 11, 2010 at 9:37 am
tripower (8/11/2010)
August 11, 2010 at 9:34 am
Viewing 15 posts - 16 through 30 (of 95 total)