I have a question for all you folks claiming that every table must have a natural key.  What would you use for a natural key for either...

Well login to the server with the service account and see if it can access D:\_SSISFiles\Scripts

🙂

I have a question for all you folks claiming that every table must have a natural key.  What would you use for a natural key for either an Employee...

You can organize them in folder in MSDB or in the file system but not in VS sadly.

Again you're missing the point about numbers not being the same as numerals

So here's the definition of a numeral, a figure, symbol, or group of these denoting a number.

Seems like a numeral is...

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

Your $excel.Workbooks.Open($element) is just converting the element with a simple tostring which just returns System.Data.DataRow

Try $FilePath = $element.FilePath

No, Jeff, an identifier is by its very nature measured on a nominal scale. It is not an interval scale. It is not a ratio scale. It is not...

There's nothing inherently wrong with views in stored procedures.  However if the data from the view doesn't change during the entire batch process you might consider preloading the data into...

What I'm really getting at is that a lot of Developers that I've worked with at other companies think that they don't need to test their own code as...

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

That works.  But, you may see additional errors appear when running the app. The app may have something that tries to modify the database(s), such as shrinking(!) or something...

By including Z in the where clause you've effectively turned it into an inner join.

Hi Guys, thank you all for your reply. another manufacturer is no alternative according to the department. However, I also want to prevent the db from doing mysterious things....

Yes I've seen applications that for whatever reason require both sys admin access to the instance and specific collations on system DB's.  I would just give the application it's own...

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

I'm not sure what Talend offers, i have no experience with it, but i know its either super simple and will not fill your needs or non-devs wont have...

So you have two points.

First letting non developers do ETL, while companies will love to pitch you all day about how easy their drag and drop tool is for non...