SourceObjectName empty

FAQ

Profile

SourceObjectName empty

Database Forums (Home) -> DTS

Next: How can you get the command(update insert delete)..

Author

Message

Nile

Joined: Sep 23, 2005
Posts: 5

(Msg. 1) Posted: Tue Sep 27, 2005 10:28 am Post subject: SourceObjectName empty

I'm trying to create an audit table for my data warehouse. As part of it, I wanted to add code to get the task properties and load them into a table, but the following comes back empty: msgbox(objTask.SourceObjectName) Any idea why? There is a valid SourceConnectionID, and a valid Source SQL that comes back using the same msgbox (but with the appropriate property). Thanks Nile >> Stay informed about: SourceObjectName empty

Display posts from previous:

Related Topics:

sometimes empty table after DTS - I have a couple of table in my DTS package that sometimes are empty after DTS despite Job is successful. When I run it again it can work. Is there any way to put some verification code in DTS I could check if a table is empty and I could run that..

Moving Full database to Empty database - Hello there I have database with many relationsips At the start it is empty and when i'm trying to import to it data. some of the tables are failed due to key violations Is there a way to import the data in this cases?

How to convert .HED file to SQL Database - Dear, I have a .hed file. I want to convert it to SQL Database as a data source. How can I do so? Can I export it to an Excel file? What program can I use to open it? Thank you.

howto: Export DTS Local Package and Import on Different se.. - Hi, I have a local DTS package on one machine and want to copy it to another machine via CD. I've rooted through BOL and a bit of Google but I suspect I'm not asking the right questions. Any help available here on this? An example would be great! ..

Problem using GLobal Variables in DTS Package - Hello, I use SQL 2K on a Win2K box I have created a DTS package, the data source is a stored procedure with an integer for the only parameter like: exec myproc intparm When I have a literal for the parm, it runs fine. When I replace the number wit...

	Database Forums (Home) -> DTS	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum