Search results for query: *

we can close this I recreated the package from scratch and it is now working. it appears that when the variable was changed/added after the package was built the messed up the variable so that the package could not work.

we can close this I recreated the package from scratch and it is now working. it appears that when the variable was changed/added after the package was built the messed up the variable so that the package could not work.

...types are strict, except for variables of type Object. Error: 0xC002F210 at Get View Name, Execute SQL Task: Executing the query "select 'select * , CLYEAR + CLMONTH + CLDAY + CLAC..." failed with the following error: "The type of the value being assigned to variable "User::VeiwNames" differs...

I have the names in one table. I think I should close this post and only withthe new post I have started.

...types are strict, except for variables of type Object. Error: 0xC002F210 at Get VeiwNames, Execute SQL Task: Executing the query "select 'select * , CLYEAR + CLMONTH + CLDAY + CLAC..." failed with the following error: "The type of the value being assigned to variable "User::ViewName" differs...

execute SQL task resultSetType ResultSetType_None sqlsourcetype variable sourceVariable insert into luminxclaims_temp select *, CLYEAR + CLMONTH + CLDAY + CLACLMNO from @User::TablNames ExecValueVariable User::TablNames validation error failed to lock variable "insert...

Thanks, this is a start. I'm still not sure how to build this or where to create the variable.

I'm using SQL 2008 and VS 2008 and not sure where the 'exec sql as var" is located

do you know of any examples, videos, tutorals, etc... I think I tried that but was not able to get it to compile with having issues with the variable, is the whole select statement need to be the variable or only the table name. Tia Tim.

...I tried to create an ssis package with a loop but I can't get the ssis package to compile without complaining about the ? used in the select * from ? statement. this is the only thing I can't figure out. I need to send the table name as a var and have the select use that name. TIA Tim

I have 3 SQL servers, Server O - os 2003 – sql ver Microsoft SQL Server 2008 (SP3) - 10.0.5500. (Build 3790: Service Pack 2) Server T - os 2003 -- Microsoft SQL Server 2000 - 8.00. (Build 3790: Service Pack 2) Server P - os 2003 -- Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Build...

...= '" & sqlReadform("FormPrintQueueDocID") & "' ") 'd.MailMerge.OpenDataSource(Name:="", Connection:=strconn, SQLStatement:="SELECT * FROM iDocPrintRewriteBills WHERE DocId = '" & sqlRead("DocId").ToString & "'") d.MailMerge.Destination =...

the concern that I had about the OEM version, was the mixed messages that I found on the NET. for ex: A CNET article about the OEM version stated that MS was changing their licensing of the oem version and the some MS websites stated that it was not valid for people like me to install a copy on...

kjv1611, Looks like an "in place" upgrade from xp to win7 is out and I prefer to format and start over (get rid of bloatware etc..) was just about ready to format and reinstall XP Home over again but need win7 for BF3 there is a Tranfer tool (MS WET?) that can move files and settings to a...

I think the confusion is the MS Terms. I think upgrade refers to "in place", keeping your files and settings, and non-upgrade means "clean install" only, format you HD and start over. so, one might be able to use the Upgrade version but will lose the setting and files (if the transfer tool is...

Thanks, I'll see what that link can tell me. like I said too may conflicting posts about it. ( from the "can you get a stright answer from MicroSoft" dept) and... according to this microsoft site you should be able to upgrade from xp (all versions) to win7 pro. (using custom option)...

I seen the MS video on upgrading from XP and needing to use the custom option/clean install (also using the Windows transfer tool.) but it did not mention which media version was need. just a few media option that I've seen: 1-windows 7 retail 2-windows 7 upgrade 3-windows 7 system builder...

what windows 7 pro media do I need to upgrade from xp home. ( looking at the PRO version, mainly for the xp mode option) as I understand it, a clean install is required. which as i understand it. the retail media version of windows 7 is only version that you can use for this(running about...

Thanks, I'll look at your suggestions.

How do I tell what computer sent a PSshutdown command to my computer? last night at 6:30 my machine shutdown. the log shows the administrator account was used but no workstation id was listed. is there a way to log where the psshutdown is coming from??? TIA Tim