not to that level of granularity, but there is a way to code around that.

take a look at this post from a while back where i posted a complete solution...

i hope i am not reading this wrong, but it looks like what you want to do is instead of using SELECT *, to select explicit column names.

good job on...

then in that case, why don't you simply put all of the servers in Central Management Servers, and execute then via SSMS all together?

stick with the tools you know, isntead...

with powershell, here is how i would do it.

Assuming instances_list.txt is a single column list with no header.

also assuming the script has USE [somedb] or fully qualified names so it...

on each server, can you check this Server Setting?

Perform Volume Main task for fast database creation.

if you changed the service account after the initial install, i might expect to see...

here's a snippet i use:

this will return all failures since the given date(first of the year is my parameter)

you can tweak it from there, i think.

DECLARE @dt...

the SQL Import Wizard will let you select all 260 tables in one go, and save the package for future editing, execution and modification.

one package, 260 data flows.

does the application NEVER write to the database and needs to be fixed, or does the applicaiton writing to the database works for a while, and the stops writing?

there are...

• This reply was modified 6 years, 2 months ago by Lowell.

yes the code has problems, since . the code you pasted is incomplete.

for what you pasted, besides having a lot of whitespace so the...

if you are sure they are using the same sources, then how about a quick and dirty row count and totals by columns?

add some additional group bys to look at...

i might consider checking the  ansi and date_format sessions settings for default dates, as they could be different on the server, running as an agent , vs running in SSMS

ie...

without using .NET, then no, the specific file extension *.msg ends up requiring C# to do something like this, since the msg is a binary file:

you could save as text...

qadding the columns them selves is just a DDL operation. you would not need to do that inside SSIS.

ALTER TABLE ADD Column1 varchar(etc...

i suspect you mean what about the data...

BIDS is the older version for SSIS development from SQL2005 to SQL2008R2

in 2012 and Above, BIDS had a name change to SSDT(SQL Server Data Tools). it is basically the same...

i think this will fix just two items though; won't he have continued issues when he discovers %20 or other url encoded values?

i would think  we need to consider all...

• This reply was modified 6 years, 3 months ago by Lowell.
• This reply was modified 6 years, 3 months ago by Lowell.