sorry, I meant expanding

We have triggers to capture the changed data of a table.

Alvin Ramard (3/19/2015)

---

Yes you can take one file and in one data flow, insert any column(s) you want to one or more tables.

You could also do this in multiple data...

CKX (3/19/2015)

---

Guras (3/18/2015)

---

Can we bulk insert only the desired column from a flat file to a table?

I am using SSIS to bulk insert from a file with more than...

So I do I get around it any idea?

No. I am building the where clause based on the rows for matchId 1 from the table. I want all the matching rows concatenated to a string as the...

I came across this example. This is exactly what I wanted to do. It works great! I could even leave the MaximumErrorCount property of the Foreach Loop to 0.

Now working...

I tried this but the connection does not move to the next

public void Main()

{

...

GilaMonster (2/6/2015)

---

No, you do not.

Altering a table changes the schema version of the table. As part of the pre-execution validation of a cached plan, the schema versions are checked to...

Thank you that was it the user1 can grant permission to other users now. However we are running into another problem where the GRP1 cannot find the procs created...

I would take a full backup and a transaction log back up since then and see if the log file size has gone down.

What is the recovery model of the MSDB database. Is it in FULL and you are not doing periodic transaction log back up?

Thank you!

This is what I found out

If an index is created and rows are inserted after the creation of the index the result of dbcc show_statisitics will be empty.

dbcc...

GRP_USers_1 and GRP_Users_2 is AD groups. Okay creating a role and adding these users to this role is a better option. But what are the downside of going by AD...