Hello guys,

Thank you for your reply.

Since I published this topic on the 3d of October & today is October the 29th I could not wait so long and found the...

Steve,

You are a genius. Thank you so much.

Steve, thank you for quick response

I did all of that, but unfortunately 'Text File Group' wouldn't change from DEFAULT (until you will modify a default File Group back and forth...

Thank you Gary,

This worked on a Test database, but I would definitely prefer a different solution.

It is kind of scary to change a Default File Group in your production Database...

Thank you guys for your response,

Yes, I can move a table structure to a different filegroup with no problems.

But I cannot change a filegroup for the data in the...

David,

Thank you for your quick response. I'll definitely look into Visio. I would prefer to have a graphic designer built in SQL Server, though.

About your question.

You probably heard about...

Thank you guys so much for your response.

There is no 'Disconnected Edit' option in SQLServer7, but I guess that 'Use OLE DB Service Components stands for it?!

I unchecked it and...

James,

Thank you for your response. Actually, in SQL7 there is no tab for Logging in Package Properties; but you can specify the logs inside the package.

And yes, it will...

I basically have the same issue with one of my packages. It runs fine in EM but never completes as a job, scheduled from this package (not fails though).

So, I...

James,

Thank you for your quick response.

Unfortunately, I cannot see any errors because a job is hanging in 'Executing Job Step 1' mode.

I even cannot see event log because this...

Jody,

Sorry I didn't have time yesterday to thank you for your advise.

It worked for SQLServers on WIN-2K & WIN-XP machines, but didn't work on WINNT machines.

Now, it looks like...

Jody,

You are probably talking about SQLServer2000. There is no 'nt account' under Security in SQLServer7 Enterprise Manager. I don't think it's so easy (May be it is?).

Look at this article...

Preview

I'm executing a DTS package which consists of 2 tasks:

1. Microsoft OLE DB Provider for SQL Server Connection

2. Execute SQL Task

In Connection task I was using Windows NT...

James,

Thank you for your response. I can open file using a network share in any of these programs.

To tell you the truth I think that the basis of your...

I was waiting for 3 days. So, I guess nobody can answer my question.

I will appreciate any response.

Sincerely,

Alex