Viewing 15 posts - 46 through 60 (of 167 total)
Thanks LutzM!
I have attached the data in ready to use format (INSERT INTO TABLE () SELECT VALUES()).
Also attached sample data in xls format as well as .txt format.
User's last...
July 16, 2011 at 6:58 am
ssismaddy (7/15/2011)
In the Job Properties ->Steps, Edit the step and go to advanced. You will find include step output in history, check that option.
Perfect. Now I see the Job view...
July 15, 2011 at 8:35 am
Hi John, Thanks for your reply.
Created a scheduled plan in maintenance plan itself. So automatically job is created and running as per schedule.
This is only maintenance plan I created in...
July 15, 2011 at 8:07 am
LutzM (7/6/2011)
It can be any of the three updates using a subquery.
The TOP 1 ORDER BY...
July 6, 2011 at 2:41 pm
I have corrected the metadata in data source and ran the package, still getting error
Package execution results:
…
….
[Flat File Destination [61]] Error: Data conversion failed. The data conversion for column "entryanswersfreetext"...
July 1, 2011 at 11:26 am
rgtft (7/1/2011)
What happens when you change your data source's SELECT to put double quotes around that field?
SELECT '"' + [FreeTextColumn] + '"' AS QuotedFreeTextColumn
I am getting package validation error.
Package validation...
July 1, 2011 at 10:20 am
most of the rows have a "
also have comma's in most of the rows.
Is there any way in SSIS package to resolve this and export the data correctly into...
July 1, 2011 at 10:06 am
Hi Krish,
Indexes are stored separately from tables, thus overall database size increases. A properly selected index can increase performance. A poorly selected index can actually slowdown your database.
When to use...
July 1, 2011 at 8:58 am
PaulB-TheOneAndOnly (6/24/2011)
laddu4700 (6/24/2011)
Any idea what is evault backup and difference between evault and SQL agent backup jobs?Yes! 🙂
I did't get you.
June 24, 2011 at 8:35 am
And also wondering can I take the hardcopy of diagram?
Not sure what you are asking? Do you mean print the ERD from Visio?
[/quote]
Yes, I meant taking print -hard copy of...
June 20, 2011 at 12:24 pm
Is it fair to provide the unique identifier (generated by our system).
Just wondering how they sync username with unique identifier in their system
any suggestions for best practice. THanks
June 6, 2011 at 2:58 pm
Resolved.
parent table column referring itself. that is why my sp is getting error nesting level exceeded (limit 32).
I have modified SP and it worked
WHERE SO2.Name = @cTableName and so1.name <>...
May 22, 2011 at 10:27 pm
Hi,
Looks like my question is related to this thread.
I am trying to delete some rows in parent table and related rows in child tables. I am using below sp, but...
May 21, 2011 at 3:02 pm
Thank you for your reply.
i did't get you exactly
But I am trying to update the sp, updating in where clause will work it seems.
WHERE SO2.Name = @cTableName
May 21, 2011 at 2:19 pm
thanks, how can i do this, you mean setup a trace in sql profiler
In SQL 2008, I could see audit option, is these security events are possible to track with...
May 5, 2011 at 8:51 am
Viewing 15 posts - 46 through 60 (of 167 total)