psangeetha (10/17/2008)

---

Hi all,

I have a table called case and there is an insert script to insert a record into this table.

insert into case_form (case_name,case_seq,case_cred) select...

In BIDS under connection managers, highlight the connection and go to the properties page for that connection. Use the expressions editor to build an expression for the connection. For more...

The script I sent you was for SQL 2005 - CTE (Common Table Expression's)...

Just a note that this WYSWYG editor is stripping out some of the HTML tags 🙂

Put your select into a table variable - i.e.

DECLARE @tableHTML NVARCHAR(MAX)

DECLARE @CTESales TABLE

(SalesOrderID int, UnitPrice money);

WITH CTESales AS

(SELECT ROW_NUMBER() OVER (ORDER BY UnitPrice DESC) AS RowID, * FROM Sales.SalesOrderDetail)

INSERT...

latingntlman (10/17/2008)

---

I just tried to run the code but I'm getting error msg:

Msg 170, Level 15, State 1, Line 10

Line 10: Incorrect syntax near '('.

Msg 156, Level 15, State 1,...

You should be able to do this via WMI - see BOL for example -

http://msdn.microsoft.com/en-us/library/ms186385(SQL.90).aspx

Not sure if I understand exactly what you are trying to accompish but try using a CTE - i.e.

WITH LastUpdated AS

(SELECT ROW_NUMBER() OVER (ORDER BY CHANGEDATETIME DESC) AS RowID, *...

Try -

DECLARE @ObjectName SYSNAME,

@ObjectType VARCHAR(5)

SET @ObjectName = 'etl_status'

SET @ObjectType = NULL

BEGIN

DECLARE @ObjectID AS BIGINT...

As Grant mentioned previously; it is most likely statistics. Update w/ a fullscan on all of your tables - i.e.

SET NOCOUNT ON

DECLARE @Table TABLE

(

Id INT NOT NULL IDENTITY(1,1),

TableName...

You can do this in a script transformation using something simlar to the script below. Please note it makes use of an ADO.NET connection for the lookup (represented as LookupConnection)....

NP - glad to hear you figured it out 🙂

Ok, reason I ask is you typcially have to precompile the code on an x64 system. Hopefully deleting and recreating the script task will do the trick - has worked...

Are you missing any references? Is this an x64 or x86 system? Have you tried copying the contents of the script task to the clipboard, deleting the script task and...

Perhaps this will be of assistance 🙂 I wrote this a while back to check for the existence of a file in a certain directory. It populates a boolean variable...