biotec
asked on
SSIS getting invalid object error when running basic t-sql tasks
I have a query that runs fine in SQL but not in SSIS. I get the following error:
"Invalid object name 'GPRA_Totals'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
This is the first step it tries to handle,
insert into GPRA_Totals(DateLoaded)VAL
(CONVERT(VARCHAR(50),GETDA
"Invalid object name 'GPRA_Totals'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
This is the first step it tries to handle,
insert into GPRA_Totals(DateLoaded)VAL
(CONVERT(VARCHAR(50),GETDA
post your query.
ASKER
The table does exist. This is the first part of the query:
insert into GPRA_Totals(DateLoaded)VAL
(CONVERT(VARCHAR(50),GETDA
Next it just tries to do an update:
UPDATE GPRA_Totals
SET UserPop = (SELECT COUNT(*) FROM vw_GPRA_UserPopulationDeno
WHERE DateLoaded = CONVERT(VARCHAR(50),GETDAT
insert into GPRA_Totals(DateLoaded)VAL
(CONVERT(VARCHAR(50),GETDA
Next it just tries to do an update:
UPDATE GPRA_Totals
SET UserPop = (SELECT COUNT(*) FROM vw_GPRA_UserPopulationDeno
WHERE DateLoaded = CONVERT(VARCHAR(50),GETDAT
ASKER
I do not have any data flow tasks in my SSIS package as I'm not sure I need them in there.
If you go to Management Studio, can you run the following query in your database? SELECT * FROM GPRA_Totals
If that doesn't work, you probably need to create the table. If that does work, then go back into your SSIS package and make sure the connection manager that your task is using is pointing to the correct server and database.
If that doesn't work, you probably need to create the table. If that does work, then go back into your SSIS package and make sure the connection manager that your task is using is pointing to the correct server and database.
No, you don't need a data flow task if you are using a SQL task.
ASKER
Did all that and it all works and is set up correctly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Now I get:
[Execute SQL Task] Error: Executing the query "insert into ngprod.dbo..GPRA_Totals(Da
[Execute SQL Task] Error: Executing the query "insert into ngprod.dbo..GPRA_Totals(Da
post your query
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ahhh...good catch. totally missed that one.
Make sure that the GPRA_Totals table actually exists in the database you are connecting to, or if you are creating the table in the SSIS package, you can open the properties of the SQL task and set the BypassPrepare flag to True.