• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 539
  • Last Modified:

DTS Transformation Script - how limit rows?

I'm using DTS to copy an Excel spreadsheet to a SQL table.
In the transform scripting area, using VBScript, I'd like to limit the number of rows processed. How do I do this?
1 Solution
You cannot do that. VBScript is used to transform the data (i.e substring, concat, ucase, etc.) but the row itself will be inserted into the destination table. In short, rows filtering is unavailable.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now