Phil Parkin (3/25/2013)

---

In my opinion, the lookup is unlikely to be the main culprit here. I'd be looking...

In my opinion, the lookup is unlikely to be the main culprit here. I'd be looking at the...

Check out the T-SQL Year(), Month() and Day() functions - you can do this at source.

From Access to SQL Server, presumably?

So you want to create a loop which iterates around all tables in a selected Access database, and for each table it should create the...

Good answer Sergiy.

Can you provide a bit more background?

What do you want to do with the schema once it has been extracted?

Shaira (3/18/2013)

---

What is the best way to share an SSIS package? I have a sister office who receives all the same data I do, but they have a completely...

opc.three (3/14/2013)

---

Have a look into EncryptSensitiveWithPassword the option. You could also look into using a Package Configuration (of some kind) to store the connection string with the password in it...

AllanP999 (3/13/2013)

---

Thankyou for you reply.

grps can be updated many times on many dates, so can appear in the table many times.

The table is ordered by date, so I am only...

happycat59 (3/13/2013)

---

Coincidentally, I had a similar problem just this morning with a sproc that calls msdb.dbo.sp_help_job

Have a look at http://connect.microsoft.com/SQLServer/feedback/details/737341/sql-server-2012-openrowset-on-msdb-dbo-sp-help-job-throws-error

In particular, the syntax used in the first workaround. The...

Barkingdog (3/14/2013)

---

A few points:

1. Yes, these are fixed width files. The main annoyance I encountered is that SSIS would not let me define all the connections in one shot. I...

Table by table. As long as SSIS can recongnise and use the driver OK.

The Import Wizard may help speed development of your import.

daniel-johnsson (3/14/2013)

---

Hi Phil and Lynn,

I have been trying to solve my problem with your instuctions but I'm still not able to work it out I'm afraid. Maybe I am missing...

Or use MAX(Getdate()) rather than grouping by it.

You might be right. Why not try changing your getdate() accuracy to one minute to test your hypothesis?