Issue during target load
Moderators: chulett, rschirm, roy
Issue during target load
Hi,
Unable to prefix schema name in the ODBC stage which is target (only insert records), the target database is MS SQL Server.
The way it is given in the job is #DBname#..tablename and when run it errors out but when given as only tablename without prefix then executes fine.
Is there any way by which the prefix can be included?
Appericiate your time, thanks
Thanks
Unable to prefix schema name in the ODBC stage which is target (only insert records), the target database is MS SQL Server.
The way it is given in the job is #DBname#..tablename and when run it errors out but when given as only tablename without prefix then executes fine.
Is there any way by which the prefix can be included?
Appericiate your time, thanks
Thanks
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You posted in the wrong forum. The forums here are based on product & job type and this one is for questions specific to the Information Analyzer product.
Question on Parallel jobs belong in the Enterprise Edition forum. I'd move this myself if I had the power but I don't here.
Question on Parallel jobs belong in the Enterprise Edition forum. I'd move this myself if I had the power but I don't here.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers