Jeff Sacksteder

247 reputation

bio	website
	location
	age
visits	member for	1 year
	seen	Jun 16 at 4:15
stats	profile views	20

	247 reputation	bio	website		visits	member for	1 year
16 badges		location			seen	Jun 16 at 4:15

summary answers questions tags badges favorites bounties reputation activity

45 Actions

suggestions reviews revisions comments badges posts accepts all

Jun 12	accepted	'skip rows' in a flat file source does not work as advertised
Jun 12	comment	'skip rows' in a flat file source does not work as advertised Not sure which you are referring to here. If I add two delimiters to the blank line, the source succeeds, meaning it is validating those rows, even if it intends to skip them.
Jun 12	comment	'skip rows' in a flat file source does not work as advertised I can't do anything in the dataflow, since the source source fails validation.
Jun 12	revised	'skip rows' in a flat file source does not work as advertised added 230 characters in body
Jun 12	comment	'skip rows' in a flat file source does not work as advertised I think the meaning of that is 'don't validate at design time'. The validation still happens at execution and apparently that includes the first few rows of the data, including the ones I wanted to skip. In any event, I still have the error after trying it both ways.
Jun 12	asked	'skip rows' in a flat file source does not work as advertised
Jun 12	answered	how to convert a table into second normal form
Jun 11	answered	Is there a way, in a single SQL statement to ensure that all items in a list are present in some column?
Jun 11	comment	Accessing environment variables at design time in SSDT? I believe so. The connection manager fields have expressions that include variables. Those variables come from parameters. In the catalog, parameters can be provided from environment variables. In SSDT, they can come from configurations. I am try to learn if external data can be included in configurations and when that inclusion happens.
Jun 11	asked	Accessing environment variables at design time in SSDT?
May 28	asked	Addtional configuration when deploying Data Tier Applications?
May 26	awarded	Teacher
May 26	answered	Debugging SSAS Timeouts
May 26	comment	Debugging SSAS Timeouts Profiler says 'query timed out'. Unhelpful.
May 24	asked	Debugging SSAS Timeouts
May 24	awarded	Yearling
May 16	asked	How to remove leaf member values?
Mar 22	awarded	Commentator
Mar 22	comment	Limit connection rights on SQL Server I'll have to install a mixed-mode instance to verify, but it doesn't appear that any additional information is available to the logon trigger. Good to know, however. I was not aware of that feature.
Mar 22	comment	Limit connection rights on SQL Server 2012, but I have downgrade rights if necessary. This app is definitely getting it's own instance.