Execute SQL Task - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Execute SQL Task

Author

Topic

Haarish
Starting Member

30 Posts

Posted - 2009-09-09 : 07:01:18

Hi All,

I have an Execute SQL task in my SSIS package that contains a query like this:

SELECT cast(LEN(SUBSTRING(CAST([ColumnName] AS varchar(MAX)), 1, CHARINDEX('string', CAST([ColumnName] AS varchar(MAX)), 1)))
- LEN(REPLACE(SUBSTRING(CAST([ColumnName] AS varchar(MAX)), 1, CHARINDEX('string', CAST([ColumnName] AS varchar(MAX)), 1)), '', '')) as integer) AS FieldName
FROM Table
WHERE (CHARINDEX('string', CAST([ColumnName] AS varchar(MAX)), 1) > 0)

I have mapped the output of this query(one row result set) to a variable. When i execute the package the package errors out saying '[Execute SQL Task] Error: No connection manager is specified.'.
When I replace the selection with an integer and execute the package it completes successfully. Can you spot any problems with my query?

Thanks in advance,
Haarish.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-09-09 : 09:05:15

Error: No connection manager is specified means that you have not given a server connection to the task.
Which SQL Server are you running the query against?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources