Yeah, Des, there's really no GOOD way to map the view's columns.   After all, the purpose of a view is often to obfuscate the existence of the table for security...

There's quite likely a difference between the two packages...  I'd examine both dtsx packages with a file comparison tool and see what is different.   There are ways to tune a...

Not really...   again, I'm not talking about changing the connection manager's file path.  That's already coming from a package variable.   I'm talking about dynamically changing which connection manager a Flat...

• This reply was modified 5 years, 2 months ago by sgmunson. Reason: spelling

I hate to venture a guess, but while I'm just as curious as to what the original poster meant with the extraordinarily vague wording provided, I just can't help wondering...

Well, ... there's still no response from the original poster with an execution plan...

So, while we can all speculate as to what's going on, and ponder on what the value...

Okay, but that doesn't tell me anything about the exact how, nor does it solve the need to change the connection manager for the Flat File Source.   Just telling me...

If you are using Lookup to get multiple values, that's the wrong tool for the job.   Also, how were you planning to display the multiple results you were expecting?   If...

What about INFORMATION_SCHEMA.COLUMNS or sys.columns ?   Do you not have access to either of those?  It just seems to me that those would make it far easier than trying to...

SSIS and SSMS are in two different categories where connectivity is concerned.   SSMS has that import ability at only the most basic level, and can't be effectively optimized, whereas SSIS...

I am in the process of converting an access query to T-SQL. There is an IIf statement which I am having trouble translating.

SUM (LOTOSMIS_ACC_TYPE.sing_ind * LOTOSMIS_RET_DAILY.grs_amn *

iif( gm_cd in...

Hi,

Currently i having SSRS hosted in ASP NET Web Applications Portal.

It will connect to my SQL Server Stored Procedure for query records.

The issues is, when the month range...

I'd very much favor a nightly job...   might want to investigate "Automate", which can make automating a nightly web-site download into a piece of cake...   It's not free, but it...

Well. with a billion rows, an insert might have to also compete with other processes that may hold locks on the table.   It's not really a "simple insert" when the...

Yep... there's more than a few details missing here...  no table description, and no description of the "why" behind doing all those individual OPENROWSET selects.   As there's no description of...

I'm pretty sure that's not an option, ... although I'm certainly willing to be proven wrong.