I wouldn't think so unless the page does something odd to the datas format. Seems like an understood character but IE seems fine here. I would check into the driver...

Not sure I understand what you want to know. If the questions is must you use dbo.function then yes, you have to specify the ownername when using a UDF. See...

Also look at the paging file, could be swapping or in the temp folder of the machine. Seems odd though the size would be relatively the same.

"Don't roll your eyes...

See also thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4479&FORUM_ID=19&CAT_ID=3&Topic_Title=Improve+Time&Forum_Title=Data+Transformation+Services+%28DTS%29 is related with some more info.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Also, how is you SQL Server Agent configured to connect to SQL Server? Right click Agent in EM and choose properties. Then on the connection tab you will see "SQL...

You should be able to keep the connection for the duration of the application without issue. The only extra things you may want to do is set a connection timeout...

Wow, thanks Andy, something new for me to play with.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Using the Import/Export Wizard, when you get to "Select Source Tables and Views" screen in the grid slid over to transform for the items selected and check the output size...

Although not advised it should work. But to make sure you don't have problems with it you should make sure you create the files large enough to avoid doing this...

Unfortunately you cannot set a variable equal directly to the output of the execute process and sp_executesql will only return 0 if success. You will have to use a temp...

When you get to the point in your Import where you select the sheets to import to SQL "Select Source Tables and VIews" in the grid slide over to the...

With the Import/Export wizard. When you get to "Specify Table Copy or Query" select "Copy objects and data between SQL Server databases", then next screen "Select Objects to Copy"...

No known issues except resource needs may make for one or the other slower in response.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Well, I can offer lots of advice but what do you have to work with as far as network an server hardware and current setup on DW. One thing you...

I' sorry I am having one of those brain dead days. So instead of descriding right myself take a look here this should help better than I am. http://www.sql-server-performance.com/statistics_io_time.asp But...