muhammadrazzaqpk-1032285 (12/8/2011)

---

Thanks - I have given it every try - As you know I am not good at all with powershell scripting but it will be helpful for me if...

Try moving the open quote onto the same line as the invoke-sqlcmd -query. I think it has to do with white space and how it is reading the script. I'll...

You can create a SQL Agent Powershell job likethis:

$instanceNameList...

Thanks for the link. I'm suprised that it is no longer offered from the SQL Server page.

I found that if I clear the table and insert the date/time from the variable then it is working. When I try to do it as an UPDATE of...

Hi Jack,

The script task variable is type date and the ssis and sql server variables are type datetime.

It sure seems like the smalldate issue is what is happening but I'm...

Thanks for the responses.

I am always really happy to learn something new. Using CTE, there is a lot that can be accomplished.

Yes, it can all go in one temp table.

Thanks for the suggestions. Appreciate your help.

Passing a variable into an OPENQUERY without dynamic SQL isn't working for me.

DECLARE @VAR varchar(100) = '12345'

SELECT * FROM OPENQUERY(ADSI,'SELECT ManagerEmployeeNumber, mail,displayName

FROM...

Actually the dynamic sql is because I was not sure how to pass a variable to an OPENQUERY without structuring it first then executing it.

Thanks Jared.

The temp table approach is how I ended up doing it.

The DynamicSQL was from when I thought that the variable would have to be changed. Prob isn't necessary with...

Managed to do it by dumping the queries into temp tables and then selecting from there. Probably not the most efficient way to accomplish this.

create table #temp

(

displayName varchar(500),

mail varchar(100),

manageremployeenumber int

)

create...

Thanks for both of the examples. Both helped me get the query to work.

Howard

It is working now. Thanks for the tutorials.

Howard

Thanks Evil Kraig F. Much appriciated.