debrarowens (12/10/2012)

---

All data elements are variable length, except for company which is 3 in length.

DT_STR does now allow a variable for the length field.

There are 5m+ rows to load.

---

Then only...

debrarowens (12/9/2012)

---

I'm moving data from a text file to a table using SSIS.

Below is an example of my data and how it needs to be broken down.

To extract the ID...

Lynn Pettis (12/8/2012)

---

CELKO (12/8/2012)

---

Getting toasted by me is a ritual of...

JimS-Indy (12/8/2012)

---

I read an article on SSC.com about putting SSIS log messages (specifically, in this case, error messages) into a table so the table could be used to send an...

shannonjk (12/8/2012)

---

Also one further quick question; since I do have 75+ tables I am loading on a nightly basis...would I just create multiple jobs to handle this load instead of...

shannonjk (12/7/2012)

---

I am aware of how to query data based on the entry dates and change dates. If it were a simple matter of throwing together some SQL then I...

scottcabral (12/6/2012)

---

I need to create a Distinct count measure on a varchar field that exists in my fact table. the field is actually a Degenerate Dimension called Claim_Num.

When i try...

shannonjk (12/6/2012)

---

Hi Robert thank you for your response!

To answer your questions; Yes there are Modified dates and Created dates (In our system they are called Change Date and Entry...

bobd125 (12/5/2012)

---

What is the best way to make your SSIS Data Flow to fail upon a data condition check. What I'm doing is reading a flat file that...

shannonjk (12/5/2012)

---

So I will keep this concise as I can; I have a source as400 system I am extracting data from for a Data Warehouse. The standard method is to...

Are you saying...

Take a look at this article by Lynn Pettis to see if that helps: http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

Rob

Unfortunately, SSRS is not WYSIWYG. It generates HTML to create your report. This HTML can/will be displayed differently depending upon your browser (IE, Firefox, Chrome, ...).

If it prints...

I ended up using a table variable rather than the CTE:

DECLARE @Temp table (

Id int NOT NULL,

FranchiseId int NOT NULL,

SalesOrderNumber int...

jdbrown239 (11/28/2012)

---

I get a package that fails sometimes with the following error. The package queries a view that is converting xml data and creates a flat file. Has any...