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.

<<You should have a Execute SQL Task that retrieves the list of table names from the database AND assigned it to a variable of type OBJECT; resultset is "Full result set". >> I think I did this already I did have to create the object var two vars are viewnames is object type Viewname is...

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

------------ I'm trying to read several table/views from a third party database and combine them into one table in our sql database. I think I got the ssis package built the way I think it should be. but I'm getting error when I debug it. I think I got the variable setup correctly for what I'm...

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.

we have a third party DB that creates a table for every new group added. ex group1 will have a table clmsgroup1 group2 will have a table clmsgroup2 etc all these tables in this database have the same column layout. how do I create a ssis package use a list of table names as a var...

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...

Im getting the following error There is already an open DataReader associated with this Command which must be closed first. with this code at the second ExecuteReader() (is it the way I coded it or is it the sql 2000 engine?) Sub PrintBillCarriers(ByVal docType As String) Dim jeff...

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